Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Read Only Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andrew - 24 Jul 2007 15:24 GMT
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?
scubadiver - 24 Jul 2007 15:44 GMT
Open the ".ldb" file with notepad but it will only give computer ID  numbers.

Signature

www.ae911truth.org

> 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?
Andrew - 24 Jul 2007 15:48 GMT
Where are these .ldb files typically located??  I'm not familiar with them at
all.

> Open the ".ldb" file with notepad but it will only give computer ID  numbers.
>
> > 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?
scubadiver - 24 Jul 2007 15:56 GMT
An .ldb file is created in the same directory as the .mdb file when the
database is opened.

Signature

www.ae911truth.org

> Where are these .ldb files typically located??  I'm not familiar with them at
> all.
[quoted text clipped - 5 lines]
> > > 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?
Andrew - 24 Jul 2007 16:02 GMT
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??

> An .ldb file is created in the same directory as the .mdb file when the
> database is opened.
[quoted text clipped - 8 lines]
> > > > 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?
Pat Hartman (MVP) - 24 Jul 2007 16:38 GMT
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.

> I've got the file open, and I am the only one listed as having accessed
> the
[quoted text clipped - 18 lines]
>> > > > a list of people who may be accessing the database at the current
>> > > > time?
Kerry - 24 Jul 2007 16:06 GMT
You should also take a look at:
http://www.granite.ab.ca/access/corruption/workstation.htm

On Jul 24, 10:56 am, scubadiver <scubadi...@discussions.microsoft.com>
wrote:
> An .ldb file is created in the same directory as the .mdb file when the
> database is opened.
[quoted text clipped - 13 lines]
> > > > 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?
Mike Mueller - 24 Jul 2007 16:16 GMT
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)

> Where are these .ldb files typically located??  I'm not familiar with them
> at
[quoted text clipped - 10 lines]
>> > to view
>> > a list of people who may be accessing the database at the current time?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.