Deleting an .idb file


Paul Fenton

How do I get rid of the lock file (*.idb) when the database is closed
and no one on the network is using it? The database in question is a
small application that runs on the server at night and none of the
staff even knows it exists. I use it to do some cleanup of the
working databases.

When I try to delete it in Explorer, I get the message "File being
used by another program".

Paul Fenton

Douglas J. Steele

That implies that Access may not have been properly shut down, so that the
operating system still has a handle open on the file.

You may have to reboot the machine.

By the way, it's ldb: l (for locking), not i.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question