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