access denied shared database

Karen L. Miller 20 Reputation points
2024-02-07T18:08:38.4766667+00:00

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?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,058 questions
0 comments
Accepted answer
  1. Peter Doering 170 Reputation points MVP
    2024-02-08T23:53:39.5433333+00:00

    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.
    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest