PeteMac

I have written an application that makes significant use of ADO connections to an Access database. This is the first application I have written using VB (v6 SP4). Everything works terrifically when single user is logged in, even over the network connections. My problem is when more than one user attempts to navigate around the same ADO intensive areas of the application. I get "Database placed in a state by unknown user that prohibits open or access to database" (I can't remember the exact wording). It can't be a Locking problem as all ADO connections are specified as Readonly, ClientSide and Static.
Is this a problem with Access running out of resources ? Has anyone got any ideas ?
All users login to the database with the same 'Admin' name with no password. I am using UDL files to specify the connectinon parameters.

quwiltw

it'd be easier to tell if you'd post a snippet of relevant code (the code that attempts the connection) When sql server runs out of resources I usually get an error message saying as much, I assume the same with Access? therefore, I wouldn't be so quick to say it "can't" be a locking problem.

dcl3500

I get that error to on occasion. I finally tracked it down to the fact that a user was accessing the same table as another user at the same time. The best solution I came up with was to trap the error then retry the operation again in a couple of seconds. As an aside though, make sure to close your connections, recordsets and what have you as soon after completing an operation. Otherwise the database could remain in this state for quite awhile.