In the drive where my database is stored, I recently noticed several copies of the .ldb file. However the date modified is not current. Ususally I see only 1 ldb when the system is opened by a user. Viewing the file in Word or Notepad will show me user names. I cannot figure out why I have copies of the .ldb in this drive. The database has been in use for about 2 years, but the oldest ldb is from 11/6. Could a user accidentally have changed something? The database name is ApplicantTracking.mdb... the subsequent ldb files read: ApplicantTracking;1 ApplicantTracking;2 etc.

Thanks!

jessica

It sounds to me that at some point this database wasn't correctly
shut down, and/or has become corrupt.

Are you experiencing any problems using it?

Can you delete the ldb files manually?

I did not yet attempt to delete them. I found it strange enough, that I wanted to ask for help first. I do not actually use the database but no user has reported a problem. I did a compact/repair just before I posted this thread, but no one is using it today. I just saw this during normal maintenance.
Let's hope the issue is resolved and I'll delete the files. I just thought maybe there was some issue with a server or something perhaps I was overlooking.

Thanks.

If you have your DB set to Compact On Close and there were some unexpected shutdowns, it will leave these files hanging out there. (One reason I, personally, do not recommend this option) They should be safe to delete.

jessica

I've only experienced problems with databases when they haven't shut down properly or
there have perhaps been network issues or corruption.

Normally a Compact & Repair would work, or even just opening the DB normally and closing
it.

If you aren't (or anybody else isn't) having problems then I would suggest just going ahead
and deleting the ldb files.

But don't quote me on that.