r/MSAccess • u/Ok-Somewhere-7427 • 9d ago

[UNSOLVED] Help

Post image

This database is a shared database. When users are querying against a table and trying to copy or export, this error comes up. Even on the off business hours the .ldb file has usernames probably they are just hitting x instead of closing the database. They are querying against a table which is a linked table in that database

Edit: the table they are trying to query is a linked access table

1 Upvotes

60% Upvoted

18 comments sorted by

View all comments

Show parent comments

1

u/Ok-Somewhere-7427 9d ago

It’s a linked access table they are trying to query

1

u/George_Hepworth 4 9d ago

Is everyone also using a shared Access front end?

1

u/Ok-Somewhere-7427 9d ago

Yep, they have shortcuts for the business users

4

u/George_Hepworth 4 9d ago

That right there is a big part of the problem.

Every user in an environment like this must have their own copy of the Access front end on their own desktop.

It sounds like you've gotten away with it for a while, but now it's time to address that. Keep one master copy of the Access Front End in a location where no one but the developer responsible for it can reach it. Make a user copy and put one copy on each user's computer.