Delete locked Access database

Question

I have an Access database (.accdb) file that must be replaced with a backup copy. Unfortunately, the file is locked with an (.laccdb) and I cannot rename or remove either file.

I don't exactly know who is locking the file and it could be contractors across the globe. So I can't just ask everyone to disconnect.

How can I unlock, remove, or rename the locked .accdb file?

Swimmingly

Answer 1

On the machine hosting the database file, open the Computer Management applet in Windows, expand

System Tools > Shared Folders > Open Files

and see if the .accdb and .laccdb files are listed. If so, try closing them either by right-clicking or by selecting the file and choosing "Close Open File" under "More Actions".

I just tried that under Windows 8.1 and it enabled me to delete a local database file that was currently opened by another machine.

Oloroso

Answer 2

Right click on the file and select 'Restore Previous Version.' I just clicked on one that was from the week prior and then the file disappeared after a few seconds.

Serendipity

Answer 3

I tried ALL the above and Nothing worked. Opened the MS Northwind and it did not give me the locked notice. I had done compacting w admin before on the current DB at no avail. I opened a new DB and imported ALL the Tables,Q's,F's, Macros and modules. No more locked file messages!!! It must have been a corruption in the database somewhere but here is the answer.

Tenne