• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2469
  • Last Modified:

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!!
0
jd6762
Asked:
jd6762
  • 3
  • 3
  • 2
  • +2
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now