laccdb lock file

[Magster]

Hi - I have a linked database and occasionaly the ".laccdb" file is still being displayed after a weekend and I know no one has been into the system for several days. Why would this lock file still be displayed? I can delete it without a problem. I tested this scenario when I've had the database open and the O/S won't allow me to delete the laccdb file.

Do I need to be concerned about this file hanging around when no one has been in the database? I don't recall this problem with previous versions of Access and I've been out of the development mode for a few years.

Thanks in advance for suggestions on how to prevent this file from hanging around.

 

[boblarson]

Actually the ldb file (from previous versions) also had this problem, if the last user out of the database doesn't have delete privileges for the folder the file is in. So, if they don't then Access can't delete the file.

Make sure all of your users have read/write/delete rights to the folder that the file is in.

 

[RuralGuy]

It generally means a less than graceful exit from the application by a user. Three Finger Salute.

 

[Magster]

I see, then maybe a little education is needed. Thank you

 

[RuralGuy]

It makes me wonder if the system was locked up for some reason. Just a thought.

 

[boblarson]

Yeah, for some reason I always forget about that possibility.

 

[RuralGuy]

Hi Bob,
That's why these are public forums and everyone gets to put in their $0.02 as you well know.