The table "tablename" is already open exclusively.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sandy1992
    New Member
    • May 2015
    • 57

    The table "tablename" is already open exclusively.

    Hi,

    Yesterday I made some changes to my table called "TASKS".

    And after that, my application is not allowing to open subform related to that table.

    See the error snapshot.

    Please help
    Attached Files
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Sandy,
    + Please pull your image out of the document and attach it directly to the post - I work in a secured environment; thus, I don't usually open files. You can also simply type the information into the post. :)

    + What changes did you make to the tables?

    Comment

    • Sandy1992
      New Member
      • May 2015
      • 57

      #3
      Hi z,

      Thank you so much for replying me. I am glad that you are there to help me.

      Luckily I had backup file saved so I am not that much bothered to use the last file. But, yeah I had to made the changes which I made to corrupted file after creating the backup.

      I made following changes:

      1) some changes in the existing table design, like changing the datatype
      2) some changes in the form which are bounded to that particular table.
      Last edited by Sandy1992; Jun 17 '15, 06:56 AM. Reason: typo

      Comment

      • zmbd
        Recognized Expert Moderator Expert
        • Mar 2012
        • 5501

        #4
        That's not much to go on; thus, unless you can be more specific I cannot offer much help.

        You mention that the file was corrupted, as such, that may have been your root cause. If you have not already done so:
        Make a copy of the file'
        Open the file
        Use the Database tools repair and compact
        Close and reopen the repaired file
        See if the error persist

        other than that... without the error message and/or specifics regarding the changes there is not much more advice to offer you.

        Comment

        Working...