Results 1 to 3 of 3
  1. #1
    sren is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    36

    Exclamation Database Lock Error 3734 - Only on Design Form in 2 Linked Database

    Help....calling on experts! I could use some urgent assistance on an issue we started encountering out of nowhere this afternoon!

    We have 2 databases: calc.accdb and proc.accdb.

    • The proc database links to a couple of tables in the calc database.
    • Other than that, the only other "connection" that the two have is the original frm_Main (i.e. Main Menu) from the proc database was imported to the calc database. In both databases, the form opens on an AutoExec macro. All code, etc., tied to the form imported to the calc database was deleted.


    All of this has worked without any problems until today. After spending a considerable time trying to figure out what the issue is, we have discovered that: if one of us is in the calc database and the other is in the proc database, and one of us (regardless of database) goes to the Design view on the frm_Main in the database they are working in, the other user who is in a totally different database (i.e. the other one of the two - proc or calc), starts receiving the 'database is locked by user xxx (error 3734)' message. The user receiving the error message can do nothing until both users completely exit Access and restart their respective database.


    Note: The ONLY other issue like this we have ever encountered is that both of us can not work in the same database like we used to be able to do in Access versions prior to 2010 where multiple users could work within the same one and we used user-level security to define who had read/write rights to which items within the database.

    I have absolutely no idea what is causing this issue or why it suddenly started happening. We are on a major crunch deadline. Can anyone please offer any insight into what is going on and how I can possibly get this resolved?

    Kindest regards!
    sren






  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    This may be a bit late considering your original post but this is what I do to avoid any problems with updating databases that are used by multiple people.

    Make a copy of the front end database to use as your development tool, this would allow you to do any testing you need and then when you've got everything working just import whatever queries, forms, reports you added into the 'working' database or just copy the entire front end database over and retain your 'updated' verson as your 'working' database.

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    I will reiterate what rpeare posted; you must split these databases. That will solve your problem.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form/Menu Question w/Linked Database
    By burrina in forum Forms
    Replies: 3
    Last Post: 12-10-2012, 03:47 PM
  2. Replies: 5
    Last Post: 05-16-2012, 12:48 AM
  3. Replies: 11
    Last Post: 07-17-2011, 08:56 PM
  4. Database engine could not lock table issue
    By ganeshvenkatram in forum Access
    Replies: 2
    Last Post: 06-28-2011, 11:41 PM
  5. Run-time error '3734': database is locked ...
    By cowboy in forum Programming
    Replies: 6
    Last Post: 07-26-2010, 08:01 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums