Table thinks there's another user

  • Thread starter Thread starter Paul Mendlesohn
  • Start date Start date
P

Paul Mendlesohn

One of my tables in a database has somehow got stuck
because it thinks that there is another user. It won't
export because it keeps coming up with the
message 'another user is accessing the data'. I have
tried repairing an compacting but it has made no
difference.
Thanks Paul
 
Hi Paul

It's most likely *you* are the other user. Are you sure that you don't have
a form or query open that is accessing the table in question?

The other thing you can try is to close the database and make sure there is
no LDB file with the same name as the MDB in the same folder. If there is
then delete it. LDB files manage the record locking in an Access database
and they can occasionally suffer from senile dementia.
 
Back
Top