Thanks for that Bill. Good information.
Glenn - Yes, that's exactly what happens. When I was developing my ShowUserRoster add-in I spent a lot of time studying locking files (you can open them in notepad). If a user logs out and then back in before the file is killed his name shows up a second time in the file.
Your reply to Liz prompted a question for me. If Joe and I connect and then I disconnect as you have described, if I reconnect, does the locking file use my original connection or does it count the new instance of me as yet another user?
255 (or maybe it's 256) is the maximum number of connections that the locking file can handle. If I connect and then Joe connects and then I close out the locking file still shows me as connected until the locking file is killed. So you can see how the connections can quickly hit the max. When I design an application I'll use an Access back end if I have 30 or less concurrent users. Any more than that and I switch to a SQL back end. You can have thousands of concurrent users in SQL...not that I've ever had THAT big of an audience. I think my biggest is around 150.
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
Pros, I have multiple users linking to the same back end database from different local front ends.
Is the max 255 for v 2010?
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: "Glenn Lloyd" <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (7)|