Jumat, 05 Februari 2016

RE: [MS_AccessPros] Re: max users linked

 

Thanks for that Bill. Good information.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 5, 2016 2:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: max users linked

 

 

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.

 

-Bill



---In MS_Access_Professionals@yahoogroups.com, <argeedblu@gmail.com> wrote :

Bill,

 

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?

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 5, 2016 11:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: max users linked

 

 

Liz

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.

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Pros, I have multiple users linking to the same back end database from different local front ends.

Is the max 255 for v 2010?

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

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" <argeedblu@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar