Hello all,
A friend of mine developed a program using vb 6 using an "MS Access" database. he used ODBC to connect the users to database over network. The problem is he needs to connect 20+ computers to this program, and all computers are equipped with winxp sp2, that as it appears does not maintain more than 10 network connections to the database.
any help or suggestions will be appreciated.

p.s. the TCPIP.sys file that open the network's connection seems to help nothing in this issue.

Regards.

ms-access has some limitations.

tell your frnd to upgrade the database to sql server or oracle.

Thanks for the advice, this is what I told him to do but the problem is that he needs "for a divine cause" to use access. any how he can access the database using MS windows server for over 30 users/players. but in the case of using windows XP as a DB server(), no more than 10 connections is available. any more help will be appreciated.

Thanks in advance
Regards.

would you please explain these more clearly?

The divine cause is that he can't work on SQL server because,as he said, there is a problem regarding queries and some laziness as i deduced. its a university project that demanded this specifications. this is regarding the 1st quote. now the second quote, when the database file is hosted on the "MS windows server 2000" it can be accessed by more than 30 users. but the problem is that due to restriction of usage of server he installed the access DB file into a windows xp station. and now he can not access the DB with more than 10 users. and I've also talked about the network connection and the TCPIP.sys fix in the 1st thread.
Thanks a lot
I hope i explained the problem more.

so ultimately your question is how you can bypass this problem so that more than 10 users can access the database synchronously in an winxp os?

if its so then the answer is you can't. this is the restriction of the os itself. so there is nothing can be done. the only solution for this you might have to change your platform for implementation. as i suggest use windows server 2003 operating system or winvista. hope your problem will be history.

regards
Shouvik