access denied shared database

Question

sometimes in the access front end with linked tables, I get a message: ... [path to data table]file already in use, how do I limit those errors?

Answer 1

Linked tables to an Access backend database? Then it is likely that ...

• Either someone has opened the backend DB and modifies tables or
• Someone else with the Access front-end has insufficient permission on the backend folder. Create/delete/read/write are required. In this case the front-end is unable to create the laccdb file (lock file) which then defaults to exclusive use.