What is the maximum number of ODBC client connection about Access Databases?

[peter]

What is the maximum number of ODBC client connection
about Access Databases?
I have heard from someone saying the maximum connections
is about 20.
Is it true?
I am confusing about what the number 20 is standing for?

For example,
I have got three access databases (a.mdb, b.mdb, c.mdb).

Which one of the following is right?! #1 or #2 ?

#1. All access database can have 20 ODBC connection
a.mdb - can have 20 ODBC connections
b.mdb - can have 20 ODBC connections
c.mdb - can have 20 ODBC connections

#2. The total number of ODBC connections is 20
a.mdb - have 10 ODBC connections
b.mdb - have 3 ODBC connections
c.mdb - so, it can only have 7 ODBC connections


Please help!
Thank you very much!!!

Peter

 

[peter]

Thanks for your help!

-----Original Message-----
This may help.

http://support.microsoft.com/default.aspx?scid=kb;en- us;815281

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]

What is the maximum number of ODBC client connection
about Access Databases?
I have heard from someone saying the maximum connections
is about 20.
Is it true?
I am confusing about what the number 20 is standing for?

For example,
I have got three access databases (a.mdb, b.mdb, c.mdb).

Which one of the following is right?! #1 or #2 ?

#1. All access database can have 20 ODBC connection
a.mdb - can have 20 ODBC connections
b.mdb - can have 20 ODBC connections
c.mdb - can have 20 ODBC connections

#2. The total number of ODBC connections is 20
a.mdb - have 10 ODBC connections
b.mdb - have 3 ODBC connections
c.mdb - so, it can only have 7 ODBC connections


Please help!
Thank you very much!!!

Peter

.