By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

File Locking Problem

P: n/a
I am having a file-locking problem with an Access database. The .mdb and
..ldb files both remain locked even after all users have closed Access.

The project is an Access 2000 database split into a front-end and a
back-end. The back-end is on a shared server on a Windows network. I am
offsite; when I want to make changes to the back-end, I use Remote Desktop
Connection to take over one of the office PCs. I always do this after hours,
when all users have closed the app. Every time I try to work on the
back-end, however, I find an .ldb file (even though all users have closed
Access) and I find that both the .mdb and .ldb files are locked by the file
system. This often prevents me from making the desired changes to the
back-end.

Twice, I have been able to reach someone in the office during these
after-hours sessions. Both times, he has confirmed that no one is running
the app. Once, I asked him to reboot the server. That worked (it freed the
files), but is not a practical solution to the problem.

My guess is that Access is not shutting down properly when users close the
app. This may be due to flaws in the app, network glitches, or both. In any
case, I am not ready to tackle that problem. My primary goal is to clean-up
the back-end ASAP, by any means necessary. Thus, I am looking for a way to
safely and reliably remove the file system locks, while using a remote
connection, without the assistance of anyone on-site.

Can anyone tell me how to do that?
-Todd Matson
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.