[AccessD] Reading an .ldb File

LOL, there is an old utility called LDBView that does this.  Just an
FYI, the .ldb file is pretty simple, if I remember right, it's in 64
byte chunks.  The first half (32 bytes) is the Computer name and the
last half is the Access User name (by default that's Admin).  Those may
be reversed.  

What's MORE important, however, is that the position of that 64 byte
chunk is related to a bit in the .mdb itself, as to whether or not that
person is actually still in the database.  (Which LDBView does that for
you, comparing the chunks in the ldb file to the bits in the .mdb).

However, as I posted earlier today, since Windows 2000, with computer
management, if you look at the server the .mdb is on, you can see who is
actually using the file, and even 'close' those connections if
necessary.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Wednesday, April 09, 2008 1:48 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Reading an .ldb File

Just for FYI:

This morning I was working with a customer where someone had opened a
database which we needed to close, but we didn't have way of finding out
who
had opened it.  Out of frustration, I made a copy of the .ldb file,
changed
the .ldb to .txt, and opened the file.  Lo and Behold - the user names
and
computer names of the logged in users were displayed.  

Interestingly, it appears that the first person who logs in has their
user
displayed as Admin, not their actual user name.  But because the
computer
name was correct, we were able to figure out who it was and get him to
close
his instance of Access.

The computer names and user names are all in the first row of text, so
you
may want to hit the Enter key a few times for better readability.

Perhaps this would be useful...!
Dan

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.