Table is locked by another session

[Kathy]

I converted an Access 97 db to Acces 2002.
Sometimes it runs Ok. But sometimes when it tries to
access a certain table (in VBA) I get the
message "...Currently locked by another session on this
machine."
I only have one instance of the program running.
I don't know what the message means or how to release the
table so I can use it. Any ideas?

 

[GVaught]

Did you recompile the database after updating? If not, you need to do this
to make sure that any VBA code has converted properly and you have all the
appropriate references. The references used in 97 may not be set in the 2002
edition.

You could also have a permissions problem on the mdb file. Make sure you
have all the necessary read, write, change permissions.