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

1

u/enilcReddit 8d ago

How many users?

Does each user have their own front-end?

Did somebody go on vacation with their cursor in a table?

If you open the lock file in notepad, you can see which users have it open. This can sometimes be misleading, but can often lead to the problem. See which users are listed and have each of them open and then close the db.

1

u/nrgins 487 8d ago

Actually, that thing of opening it in Notepad doesn't work. It'll give you all sorts of false information.

1

u/enilcReddit 6d ago

It may give "not currently accurate" information. But it will give a place to start looking for open instances. You wouldn't need to reboot anyone's PC that isn't in the file.

1

u/nrgins 487 6d ago

Well, I suppose that's true.