Nov 27, 2007

"Table is exclusively locked by user"

In this case, the Access file is locked and a lock file (.ldb) exists. The lock file may exist because a DSN of a different name is accessing the database.

Search for any *.ldb files and delete them. If another DSN (user or System) exists which is accessing the database, you may want to delete it as well and ensure that a single DSN refers to the database. Reboot the machine after making these changes.