CODEWITHSUNDEEP
excelms-accessms-access-2013
jase sykes
jase sykes

Reputation: 206

MS-Access 2013 unable to remove .laccdb locking file

This is a long shot, but does any one know how to remove the lock file created by access 2013 file type ".laccdb".

I have an excel sheet which is connected to the access database via power query. The access database is on a shared drive. However even when this file is closed the locking file for the access database is not deleted.

When trying to remove the lock file it just says that unable to close as another program is using.

I've closed down the machine, removed all temp files, checked nothing is running and also checked in computer management within the administration tools. and checked for any open files.

I know the database should be split to stop this happening. however this is not my database, and the user refuses to split.

Any help will be grateful.

Upvotes: 3

Views: 3459

Answers (1)

Tom Ewald
Tom Ewald

Reputation: 21

You can open and read the lock file with a text editor (I use Notepad++); within the file you should find the computer name (or some similar identifier) of the one(s) who have it open. You could then take that name/number/whatever to IT and see if they can identify who the user is. You should be able to close it from their computer. Hope this helps.

Upvotes: 2

Related Questions