Read Only Database

[Guest]

I am trying to open my database which I created and have used for some time
now, but I am getting a message indicating that it is "Read Only" I believe
this may be because another user has the file opened. Is there a way to view
a list of people who may be accessing the database at the current time?

 

[Guest]

Open the ".ldb" file with notepad but it will only give computer ID numbers.

 

[Guest]

Where are these .ldb files typically located?? I'm not familiar with them at
all.

 

[Guest]

An .ldb file is created in the same directory as the .mdb file when the
database is opened.

 

[Guest]

I've got the file open, and I am the only one listed as having accessed the
DB. What else could be causing this DB to be read only??

 

[Kerry]

You should also take a look at:
http://www.granite.ab.ca/access/corruption/workstation.htm

 

[Mike Mueller]

They would be in the same location as the original db, with the same name.

Typical folder contents:
-sample.mdb 7.48mb
-sample.ldb 1.0kb

Opening the ldb file on an old A97 database gives me 1 line of text:
MICHAELM Admin

which is my domain username and my rights to that db (it is pw equipped)

 

[Pat Hartman \(MVP\)]

If the .mdb file was copied from a CD, its DOS read only flag may be set.
Right click on the file name and look at the properties.