Open Exclusive Lock

[Christine]

I just split my database yesterday. My users are all in
today and using the new front-end. I tried to do a query
via MSQuery and received a "cannot access" error message
on my back-end tables. I have tried to access the tables
every-which-way. No success.

I tracked it down today to a lockout from being opened
exclusively. The problem is that I've had all users log
out and the .ldb files are still open. My database is
setup for shared use, not exclusive.

I don't know how to clear the lockout from here. I
couldn't find an answer in the knowledge base. Is there a
way to do this?

thanks
christine

 

[Allen Browne]

If all users are definately out, but the ldb is still in use, chances are
that one of the users crashed out without closing properly. If you cannot
delete the ldb, reboot the server (or whichever machine holds the back end),
and you will be able to delete it.