ror Message : The table is already in use exclusively by another user or it is already open thru the user interface & can't be manipulated programatically. RRS feed

  • Question

  • That doesn't make sense. I am a single user and not attached to a network and get this message often. 
    Thursday, May 2, 2019 8:31 PM

All replies

  • Lots of Access errors don't make sense. That's why it's so fun to work with. :O)

    Check that you don't have another instance of the database file open. I sometimes do that accidentally. Also check that you do not have a form or a VBA routine with the table as a record source already open.

    If all else fails, you might just have a slightly corrupt database. Close it and re-open it. Then compact it and try again. If that doesn't fix it, import everything into a new, blank database and delete the old one.

    Bill Mosca

    Friday, May 3, 2019 3:37 PM