MS ACCESS NO OF CONNECTIONS

  • Thread starter Thread starter Nageswara Rao
  • Start date Start date
N

Nageswara Rao

Hi,

Please let me know how many connections does MS Access 97
supports simultaneously

Regards,

Nagesh.
 
The specifications state that an MDB file can have 255 simultaneous
connections. Most developers find that optimistic. Most developers that I
have talked to find that they are comfortable with approximately 20. I have
one set of back-end tables that gets as many as 50 connections without any
corruption or locking problems. One of the companies I consult for has 42
connections, again, without any problems. YMMV.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How many users can access a database simultaneously? 7
Thai charset is problem with Sybase and MS Access 2003 2
Maximum number of pcs connected to access 1
Insert Time Stamp when macro is run 3
how many connections at maximum? 1
Performance of MS Access database 14
Access 97 using too much system resources 3
Access -- connection number 3

Back
Top