Solved

Kill MS Access Locked Database Session

Posted on 2007-04-03
4
932 Views
Last Modified: 2008-01-09
Access Database is Locked by another user on network.  I need to put a new version of the database on the network.  Because database is locked, I cant put new version on network.  How do I kill their session so I can update the database.
0
Comment
Question by:ckaliveas
  • 3
4 Comments
 
LVL 75
ID: 18848223
Can you not just get them to log off?

mx
0
 
LVL 75
ID: 18848229
If no one is 'physically' logged in, and there is a 'stuck' LDB file, try just deleting the LDB file.

mx
0
 
LVL 75
ID: 18848243
And ... if it really is a stuck LDB file, then rebooting that system will get rid of it.

mx
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 18850098

  If rebooting the server is not an option, you can use the techniques in this thread:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22423758.html

 To remove the lock on the LDB file.

JimD
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now