I'm getting error 3734 (The database has been placed in a state by user 'Admin' on 'SOLS-DC1' that prevents it from being opened or locked.) when two or more users attempt to simultaneously insert records into the same table in the backend database. Sometimes it's error -2147467259 with the same err description. This is a split design with a central mdb that accessed from distributed mde applications. Each user has their own copy of the mde. The Access version is 2002. I can reproduce this error 100% in a test environment. All users have been granted "full control" security permissions in the backend database folder. The mde files have links to the tables in the backend that they use. I have tried using ADO and DAO for the record inserts and get the same result. The code that is causing the problem is a simple loop through a recordset that builds an SQL string for the record insert and executes it each loop through. I'm thinking that this is some sort of .ldb file creation/closure that can't keep up with the access attempts. Does anyoue out there have experience with this problem?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.