Clear Access Exclusive Lock

Using an application on the workstation that accessed an Access '97 db on the network.  Had the Access database open exclusively.  The PC crashed with a fatal error.  Cannot access the db.  Get a message "DB currently open for exclusive use".  How do I clear this.  I tried deleting the .LBD file but could not.  Couldnt copt the db either.  HELP!!
jd6762Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BrianWrenCommented:
0)  MAKE A BACKUP BEFORE DOING THIS STUFF ! ! !

1) Try renaming the .ldb file, then opening the db.

2) Try renaming the .MDB file so that it will look for a different .ldb file.

3) Try making a copy of the .MDB file in a different location, opening it, closing it, then overwriting the .ldb file causing the problem with the newly created .ldb file.

4) Try opening the .ldb file from within code with an 'Open' statement, and replacing its contents with the contents of the .ldb from #3 above.

5) Try opening the .ldb file from within code with an 'Open' statement, and deleting its contents and closing it.

Brian

0
paaskyCommented:
Hi jd6762,

Create a new database project and import all tables, queries, forms, etc.. from your crashed database.

Hope this helps,
Paasky
0
jd6762Author Commented:
Thanks for the input.  I tried all the things mentioned.  cannot do any copying/deleting of file.  Called Microsoft and their solution is to kill the connection to the share drive.

Thanks
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

jd6762Author Commented:
This question has a deletion request Pending
0
BrianWrenCommented:
This question no longer is pending deletion
0
BrianWrenCommented:
Please do not delete this question.  EsPECially since it has a solution in it.

See if you can't get customer service to reduce the points and move the Q into the Previuosly Answered section, so others can refer to it later, should they have the same problem.

Brian
0
wesleystewartCommented:
When this happens in our shop, (mdb not copyable, ldb file can't be deleted, etc) our solution (as pitiful as it sounds) is to give the system 20 minutes or so.  Eventually the server will figure itself out and the .ldb file will just disappear.

I know that's a wimpy answer but it happens about once a week around here.  We call it a phantom lock.  I have never been able to delete the ldb file (which is corrupt, by the way) or move the mdb file.

Wes
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mhedenCommented:
You don't say what is acting as your server. I've had similar experiences in a Novell environment.  In this case the db wasn't open exclusively, but Access thought it had active connected users.  I was unable to compact the database and couldn't delete the ldb file either.  Using rconsole on the Novell server showed no active file locks.

In this situation I've found that the only way out is to reload the server.

Mike
0
jd6762Author Commented:
Thanks Wesley.  We waited overnight and the lock was removed.  Interesting note when I spoke to microsoft.  They said when you open a db exclusively a .LDB file is NOT created.  
0
wesleystewartCommented:
The IT guys must have recycled the server overnight.

Happy to help.

Wes
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.