I'm running a database I created for about 10 people. At the end of each day, I compact and repair it. For the last 3 days, there appears someone is locked in the database because I see a .ldb file along with the database file. This usually indicates someone is in the database but I've had everyone log out and restart their computers and the file is still there. I can't compact and repair it as long as it thinks someone is logged in it.
What could be the cause for this? I've seen this happen a couple times before but it usually takes care of itself within a day or so.
Is there away to manually disconnect the .ldb file? I can still back a backup copy of the database. I've already tried deleting the .ldb and .mde files but it won't let me do this. The main copy of the database is a .mde format.