Jumat, 05 Februari 2016

RE: [MS_AccessPros] Re: max users linked

I just brought it up again and they are going to re-address the issue.

I have SQL Server tools and dev stuff installed, just no access to a server where I could have my users have their back ends linked. They couldn't certainly link to a file residing on my hard drive could they? Not through Citrix…? That seems like a whole other slew of issues.

Maybe they will let you use SQL Express. Technically, that is a free desktop engine so it isn't as powerful as SQL Standard, but it still has most of the features which means more security and better backups. Something you might want to run by the IT powers that be.

Ah thanks Bill. I did not know that the locking file still kept the users names until the locking file was killed. Interesting.

I sure wish my company would be more cooperative and give me an sql server. I almost had it and they tossed the job around like a hot potato that finally got dropped and said nobody was responsible for it. Being shadow IT is super challenging sometimes.

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.

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.

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.

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.