By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

Concurrent connections versus concurrent users

P: n/a
Access 2K, DAO, split front end and back end; back end on server.
Regarding max of 255 concurrent users. Is it really users, or
connections? How would a user have more than one connection to same
back end? If I keep a bound form open (hidden) to maintain a
persistent connection, in what circumstances would another connection
be created? How do I count the number of connections to a back end?

Inquiring minds want to know, will be very grateful for any
clarification.

Thanks,

Krysa

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Krysa wrote:
Access 2K, DAO, split front end and back end; back end on server.
Regarding max of 255 concurrent users. Is it really users, or
connections? How would a user have more than one connection to same
back end? If I keep a bound form open (hidden) to maintain a
persistent connection, in what circumstances would another connection
be created? How do I count the number of connections to a back end?

Inquiring minds want to know, will be very grateful for any
clarification.


You'd get another connection if you used OpenDatabase on the back end
tables. AFAIK the linked tables share the same connection.

Also a query that specified a database path would open up a separate
connection.

--
This sig left intentionally blank
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.