Deleting an .idb file

  • Thread starter Thread starter Paul Fenton
  • Start date Start date
P

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
 
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.
 
Back
Top