Results 1 to 2 of 2
  1. #1
    JAL3's Avatar
    JAL3 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Location
    San Antonio, TX
    Posts
    24

    The database engine could not lock the table because it is already in use by another person or proce

    I have created a very simple database thus far. There are 3 tables: denominations, publishers, books. In trying to establish the links between the books table and the publisher and denominations table, I am unable to complete the process because I get an error message stating:

    "The database engine could not lock the table because it is already in use by another person or process."

    The db is NOT open anyplace else by anyone else. The problem has occurred whenever I try to start putting something together such as trying exercises given in tutorial texts. I'm about at my wit's end.



    Can anybody help me to understand what is going on?

    Thanks,

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Make sure all objects are closed (forms, queries, etc).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 13
    Last Post: 01-26-2018, 01:27 PM
  2. Replies: 4
    Last Post: 09-13-2017, 02:29 PM
  3. Replies: 2
    Last Post: 07-14-2014, 10:34 AM
  4. Replies: 4
    Last Post: 12-27-2012, 02:10 PM
  5. Database engine could not lock table issue
    By ganeshvenkatram in forum Access
    Replies: 2
    Last Post: 06-28-2011, 11:41 PM

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