Locked database

[florida41]

My Access Database has been in read only mode all day. If I try and bring it up it says "Read only" and says I cant add to the database. On the Windows 2000 server where it is located there is a .ldb file that says "Access.LockFile.9

Advise if this is normal for this to stay locked all day?
How can I unlock it?

 

[florida41]

Also sometimes today I dont even see the .ldb file and it is still locked.

 

[MD5150]

The lock file is how Access keeps track of who is using the database. It will delete itself when nobody is using the database, unless it doesn't have directory permissions to do so.

But off the top of my head:

- If copied from a CD, remove the "readonly" property from the file.

- Make sure nobody else has it opened as "exclusive"

- Check your Tools/Options to make sure the "open exclusive"
isn't checked.

- Check to be sure the network directory permissions are read/write/modify.

- Also, sometimes it is possible for someone to quit Access improperly due to your app locking up or whatever, but still retain a running process "msaccess.exe" on a users machine retaining the locked state. Check task manager "processes".

- Go around and make sure everyone is logged out and logging in properly avoiding the 'open exclusive' option.
Give them an icon to use.

- You can also try copying the files local to see if you still get a "readonly" message.

I'm believe there are other causes for accidentally "opening as exclusive", which you might want to search further on the internet if the above doesn't help.

- You can also have everyone log out and try deleting the .ldb file. Access will create a new one next time the database is opened.

Hope this helps,

Mike Dorthick