Locked Database

[Guest]

I have a .MDE file that will not load. The OnLoad code says

' if database locked, logout user...
If rstCCC_Security!DatabaseLocked.Value = True Then
MsgBox "Database Currently Locked for
Processing...Please try again in a few minutes..."
DoCmd.Quit
End If

I think someone tried to run a monthly close procedure that never completed.
There are NO users currently in either the FE or the MDE. The DB is set to
load the Main Form on open, which won't open.

Any ideas on how to unlock the db?

Thanks,

Patty

 

[Guest]

Patty,

Did you try looking in Windows Explorer where you have the .mde file stored?
If you see a file with the same name as your database but the extension .ldb
(when you aren't running your .mde file) then that is your problem.
Something could have been glitchy when the database was last closed and this
lock file wasn't deleted. Simply delete that .ldb file and hopefully you are
back in busines!