Exclusive access and .ldb files

  • Thread starter Thread starter John P.
  • Start date Start date
J

John P.

Can I read a .ldb file to see who is logged into an
application ?
From a problem earlier (Thanks for the help Graig - folder
had full permissions) I'd guess that if this file was
deleted users not already logged in would get
the 'exclusive access' message ?
Are there any intermittant problems known in this area ?
I'm using the NT verion of Access2000 (9.0.3821 SR-1).

I ask because my earlier problem (see Dbase always
exclusive access) has apparently just gone away without my
knowing why it happened.

Thanks for any help - this is a great service !!
 
John P. said:
Can I read a .ldb file to see who is logged into an
application ?
From a problem earlier (Thanks for the help Graig - folder
had full permissions) I'd guess that if this file was
deleted users not already logged in would get
the 'exclusive access' message ?
Are there any intermittant problems known in this area ?
I'm using the NT verion of Access2000 (9.0.3821 SR-1).

I ask because my earlier problem (see Dbase always
exclusive access) has apparently just gone away without my
knowing why it happened.
Click to expand...

You can open it in Notepad and see everyone who has been in it since the
ldb was created. Not all of the users you see would necessarily still be
in the app, but everyone using the app will be listed. There is a dll and
instructions from MS that enable you to see who is actually "still in
there" as well.
 
craig said:
John,
Notepad works great. The users will "disappear" out of
the .ldb file as they exit the database. Assuming the
folder has been setup for Read, write, modify, rights, if
3 people open the database, you should see 3 peoples
network computer names. If one closes the database, you
would then see 2 names. [snip]
Click to expand...

Was this changed after A97? I just tested it.

Opened file from MachineA, then same file from MachineB. Both appear in
ldb file. Closed file (and Access) on MachineB. MachineB still appeared
in ldb file. I tried again several minutes later and MachineB was still
listed in the ldb.

I was under the impression that the whole reason for even having the dll
viewer was because just looking at the ldb file with Notepad was imperfect.
 
Thanks for the info - I'll have a look for the dll utility.
When I first looked at Access about 6/7 years ago I
thought it was just a toy - things have changed since then!
 
Thanks again Craig - All this has prompted me to look at
making even my small application more secure - tons to
learn here !
 
Rick Brandt said:
craig said:
John,
Notepad works great. The users will "disappear" out of
the .ldb file as they exit the database. Assuming the
folder has been setup for Read, write, modify, rights, if
3 people open the database, you should see 3 peoples
network computer names. If one closes the database, you
would then see 2 names. [snip]
Click to expand...

Was this changed after A97? I just tested it.

Opened file from MachineA, then same file from MachineB. Both appear in
ldb file. Closed file (and Access) on MachineB. MachineB still appeared
in ldb file. I tried again several minutes later and MachineB was still
listed in the ldb.

I was under the impression that the whole reason for even having the dll
viewer was because just looking at the ldb file with Notepad was
Click to expand...
imperfect.


That's my understanding as well. I just confirmed in 2002 that opening it
in notepad still shows the logged off user.
 
Back
Top