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.

 

[Paul Fenton]

Thank you Doug. We rebooted and I was able to delete the ldb file.

Paul Fenton