Kram80
asked on
Unable to remove .laacdb file
I am unable to remove a .laccdb file. Says it's in use by another program. Checking open files it does not appear to be open. Tried to use appuser, but does not work for the 2007 file format. Thoughts?
Last Comment
ASKER
Yeah, if you could. The db is actually on a SAN. I was surprisingly able to connect to it via computer management to see the open files.
Have you tried reopening the database and closing it again?
Always seems to work for me, though if you didn't open the database in the first place
it might be locked by another user.
Always seems to work for me, though if you didn't open the database in the first place
it might be locked by another user.
try to fix/repair/compact db...
ASKER
Yeah, tried that. It changes the modified date/time, but will not remove the file upon closing the db.
ASKER
compact and repair didn't do the trick.
http://office.microsoft.com/en-us/access-help/introduction-to-the-access-2007-file-format-HA010067831.aspx
Locking files are deleted automatically when all users close the database.
So, make sure all users are disconnected then manually delete the file... then re-open it...
Locking files are deleted automatically when all users close the database.
So, make sure all users are disconnected then manually delete the file... then re-open it...
You can find out if the lock is for other users by opening the laccdb file in a text editor.
That won't solve the problem obviously but it might give some idea of what's going on.
That won't solve the problem obviously but it might give some idea of what's going on.
ASKER
I had the person reporting the problem reboot all PCs that could be connected to it. Unless he missed one. Strange thing is I'm not seeing anyone that has the file open when looking at open files. When I open the db, I see I have it open but it clears when I close the db.
I'm not very familiar with access, but what is a .laccdb file? I understand it's a locking file, but I'm able to open the db fine. Would it be locking them from doing changes?
I'm not very familiar with access, but what is a .laccdb file? I understand it's a locking file, but I'm able to open the db fine. Would it be locking them from doing changes?
it prevents deleting/renaming file... read the relevant paragraph that I send before...
The Access lockfile is used for several things, but the main task is to handle record-locking in a Jet (i.e. Access 2003 or earlier) or ACE (Access 2007/2010) database.
See this article: http://support.microsoft.com/kb/299373/EN-US. It is specific to 2002, but the same concepts apply to .laccdb files as well.
" Would it be locking them from doing changes"
What sort of changes? Multiple users can make DATA changes at the same time (assuming they're not working on the same set of data, of course). However, if you're referring to DESIGN changes (like adding a Report, modifying a Query, etc), then only ONE user can do this.
See this article: http://support.microsoft.com/kb/299373/EN-US. It is specific to 2002, but the same concepts apply to .laccdb files as well.
" Would it be locking them from doing changes"
What sort of changes? Multiple users can make DATA changes at the same time (assuming they're not working on the same set of data, of course). However, if you're referring to DESIGN changes (like adding a Report, modifying a Query, etc), then only ONE user can do this.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
A reboot is the simplest. If that is not possible, there are other methods, which I can post if needed.
Jim.