---In MS_Access_Professionals@yahoogroups.com, <email@example.com> wrote :
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.
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
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (9)|