Click here to Skip to main content
15,889,200 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
My application installed 250+ systems but the database(single) is shared in server machine. Which have every user read/write permission. some time I'm getting the above error from some systems.My purpose is collecting information from client systems and saving those information in server database. My database is Access Database. Someone guide me pls.
Posted
Updated 17-Oct-20 9:58am
Comments
ZurdoDev 9-Sep-15 7:34am    
Someone opened it in locked mode. What exactly is your question?
Sarath kumar.N 9-Sep-15 7:47am    
No one using the database externally. 250+ applications using the same database at same time.
ZurdoDev 9-Sep-15 7:53am    
Jet has a maximum of 255 connections I believe, but may be less due to resources. To have over 250+ connections, unfortunately, you're using the wrong technology. Time to upgrade to SQL.
Sarath kumar.N 9-Sep-15 7:57am    
Thanks for ur info.

Try changing the code accessing the databases to use optimistic locking. Ideally, also rewrite the Access database in something else. 250 applications using an Access database is asking for trouble.
 
Share this answer
 
As mentioned in comments, Jet, the engine Access uses, has a maximum of 255 concurrent connections; however, in real life you likely will not get that many due to resource issues. I suggest you upgrade to Sql Server.
 
Share this answer
 
duh....sorry folks....looking for solution myself..first time i get this "error" will try solution mentioned above...thanx....
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900