Access 2003 .ldb file is read only and cannot be deleted

[Matt]

I have a user that reported when he closes an Access 2003 database, the .ldb
file doesn't disappear and actually says it is read only. I have checked his
permissions and he has FULL access to the directory. If he logs off and logs
back in, it disappears.

It is on a Windows 2003 File Server. I have heard that this is an issue
sometimes related to access databases on a fileserver.

Any suggestions?

 

[Arvin Meyer [MVP]]

Does he have Delete permissions?

Typically, if permissions are in order, there has been an inelegant exit of
the database. This can be a user training issue, or it can be hardware
related. If this is the cause, eventual corruption is not unusual.

 

[Richard_doing_2007]

Understand that although they close the client that sometimes objects remain
behind - review the task manager pane for suspects; due to your additional
information this seems unrelated to other user's which was my primary
response. I suspect the database needs some programming fixes to fix the
issue permanently; the code behind the "close" event might be herely hiding
the client or another process was somehow spawned and continues to hold file
handles to the database.

 

[Matt]

He has all permissions on this folder based upon his group membership. It
doesn't happen all the time. But when it does, the error is that he has read
only perms. and can't delete the file. I told him to log off or reboot to
see if it releases, and it does.

 

[Arvin Meyer [MVP]]

It is possible that some code is leaving Access open. There are 2 places to
look:

1. Any recordsets not explicitly closed, as in:

rst.Close
Set rst = Nothing
Set db = Nothing

2. The other code problem is a boolean control, not explicity referred to as
in:

If chkWhatever Then

needs to be changed to:

If chkWhatever = True Then

or even:

If chkWhatever.Value Then
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com