Error: already opened exclusively by another user 1

[TimTDP]

I have an Access 2000 database that operates in a shared environment. I have a back-end database containing tables and a front-end containing forms, queries etc

All user front-end tables are linked to the back-end
This has worked well. I have just run the Compact & Repair utility to compact the back-end. Now users can't access the back-end and get an error message "already opened exclusively by another user"

How do I correct this?

 

[dhookom]

Get everyone out and delete the ldb file if present. Make sure that everyone has the ability to create and delete files in the back-end folder.

Duane
Hook'D on Access
MS Access MVP

 

[TimTDP]

I did resolve the error by making a new database and importing all the tables into it, and renamed it to the original.
However I will try your solution in future because it is much easier