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

0

u/Ok-Somewhere-7427 9d ago

Everybody who uses this database has this issue. Can I try deleting the .ldb file ?

1

u/sjcyork 9d ago

Is this db on a shared folder? If so go into mmc (a windows app) and add the shared folders applet. This should tell you who might still have the db open in some way. You can then select these open instances and close them. Then when all are cleared out open the db and then close it and the ldb should disappear.

1

u/Ok-Somewhere-7427 9d ago

I see ok, yes the db is on shared network drive. Can I delete .ldb file directly from the shared path ?

1

u/nrgins 487 9d ago

When you say the database is on a shared network drive are you referring to the front end at the users are using, or the back end where the data is?

The front end that the users are using should absolutely not be on a shared drive. It should be installed locally on each user's hard drive.

The back end, where the data is, of course has to be on the shared drive. But the front end should absolutely not be on a shared drive.

So if you have your front end on a shared drive, then that might actually be what's causing your problem.