Results 1 to 4 of 4
  1. #1
    quicova is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    53

    The Table "Table1" is already opened exclusively by another user error!!!

    Hi,

    I'm getting this error when trying to open a form with another form already open



    "The Table "table1" is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.

    never seen this before, anyone has any ideas?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    So the other form is locking the table? Have you looked at what the other form may be doing that would cause the form to lock the table?

  3. #3
    quicova is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    53
    Hi,

    yeah I did something and I don't know what.
    I deleted the form and redid it and now is fine.

    I think I mess up in the sql code of some other form. but to tired to try and find out where.

  4. #4
    akhmadahdiyat is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    21
    so it solved hah?

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

Similar Threads

  1. Replies: 7
    Last Post: 06-27-2013, 10:56 AM
  2. Replies: 1
    Last Post: 03-14-2013, 12:39 PM
  3. Replies: 1
    Last Post: 12-14-2012, 12:32 AM
  4. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM
  5. Replies: 0
    Last Post: 10-13-2009, 11:54 AM

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