The .ldb file does not always go away on DB close

[Heather]

Hello,

Can someone tell me why the .ldb file does not always go away? Sometime I
just have to delete it but I would like to know why because it is happens a
lot.

Thanks

 

[Joan Wild]

If the last person out of the database doesn't have delete permission
(Windows permission) on the folder, then they can't delete the ldb file,
and it remains.

Joan Wild
MS Access MVP

 

[Heather]

But why does the .ldb not always go away? On close it should go away but it
is not.

 

[John Spencer MVP]

Most common cause: If the person using the database does not have delete
permissions in the folder containing the database, then the ldb file cannot be
deleted when that person is the last person to exit the database.

If the person does have permissions but abnormally quits the database -
unplugs the computer, control+alt+deletes and kills the Access application -
then the ldb file won't get deleted.

If the application crashes then often the ldb file won't get deleted.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County