Query an MS-Access record locking file (ldb)

If an MDB is opened, then the record locking file appears (an LDB).

Is is possible using VBScript to query the LDB file and return its contents
using a VBS file?

If so, does anyone have any generic example code that does this, that can be
posted?

Thanks much in advance.

Bob
Fri Apr 06 15:40:15 CDT 2007

XP wrote:
> If an MDB is opened, then the record locking file appears (an LDB).
>
> Is is possible using VBScript to query the LDB file and return its
> contents using a VBS file?
>
> If so, does anyone have any generic example code that does this, that
> can be posted?
>
This topic has already been discussed today. in fact, you started that
thread. What was wrong with the answers posted to that thread?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

XP
Fri Apr 06 16:36:13 CDT 2007

Hi Bob,

After experimenting with the code that was posted earlier, I found that for
some reason, it only returned me as a user. When other users are in the file
as well, I only get myself. I tweaked it a bit and then it returned 3 users
(and three users were in the DB), but it only listed me 3 times.

I rather thought there might be another approach by perhaps direct query to
the ldb and then parse out the listed users. I can copy the ldb as a txt file
and then open it...that is as far as I have gotten; perhaps I should revert
to debugging the other method?


"Bob Barrows [MVP]" wrote:

> XP wrote:
> > If an MDB is opened, then the record locking file appears (an LDB).
> >
> > Is is possible using VBScript to query the LDB file and return its
> > contents using a VBS file?
> >
> > If so, does anyone have any generic example code that does this, that
> > can be posted?
> >
> This topic has already been discussed today. in fact, you started that
> thread. What was wrong with the answers posted to that thread?
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>

Bob
Fri Apr 06 16:54:14 CDT 2007

I'm not sure what you think you'll be gaining. That code worked by reading
the ldb file.
However, I seem to recall a utility that MS offered for reading the ldb. I
don't have the time now to search for it (I don't even remember what it was
called). I suspect you will find it via a google search of the microsoft
site.

XP wrote:
> Hi Bob,
>
> After experimenting with the code that was posted earlier, I found
> that for some reason, it only returned me as a user. When other users
> are in the file as well, I only get myself. I tweaked it a bit and
> then it returned 3 users (and three users were in the DB), but it
> only listed me 3 times.
>
> I rather thought there might be another approach by perhaps direct
> query to the ldb and then parse out the listed users. I can copy the
> ldb as a txt file and then open it...that is as far as I have gotten;
> perhaps I should revert to debugging the other method?
>
>
> "Bob Barrows [MVP]" wrote:
>
>> XP wrote:
>>> If an MDB is opened, then the record locking file appears (an LDB).
>>>
>>> Is is possible using VBScript to query the LDB file and return its
>>> contents using a VBS file?
>>>
>>> If so, does anyone have any generic example code that does this,
>>> that
>>> can be posted?
>>>
>> This topic has already been discussed today. in fact, you started
>> that thread. What was wrong with the answers posted to that thread?
>>
>> --
>> Microsoft MVP - ASP/ASP.NET
>> Please reply to the newsgroup. This email account is my spam trap so
>> I don't check it very often. If you must reply off-line, then remove
>> the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

XP
Fri Apr 06 17:40:13 CDT 2007

Thanks for that info;

The problem is, I couldn't get the other code to work...

Actually, I just finished developing an alternative to that previously
posted code.

I just open the LDB directly (i.e. no copy necessary) then simply stream the
data into an array.

Thanks a lot for your help; the help I get here in this forum has really
been superb!!! It is much appreciated and I don't think the posters get
enough credit for taking all the time to help losers like me.

"Bob Barrows [MVP]" wrote:

> I'm not sure what you think you'll be gaining. That code worked by reading
> the ldb file.
> However, I seem to recall a utility that MS offered for reading the ldb. I
> don't have the time now to search for it (I don't even remember what it was
> called). I suspect you will find it via a google search of the microsoft
> site.
>
> XP wrote:
> > Hi Bob,
> >
> > After experimenting with the code that was posted earlier, I found
> > that for some reason, it only returned me as a user. When other users
> > are in the file as well, I only get myself. I tweaked it a bit and
> > then it returned 3 users (and three users were in the DB), but it
> > only listed me 3 times.
> >
> > I rather thought there might be another approach by perhaps direct
> > query to the ldb and then parse out the listed users. I can copy the
> > ldb as a txt file and then open it...that is as far as I have gotten;
> > perhaps I should revert to debugging the other method?
> >
> >
> > "Bob Barrows [MVP]" wrote:
> >
> >> XP wrote:
> >>> If an MDB is opened, then the record locking file appears (an LDB).
> >>>
> >>> Is is possible using VBScript to query the LDB file and return its
> >>> contents using a VBS file?
> >>>
> >>> If so, does anyone have any generic example code that does this,
> >>> that
> >>> can be posted?
> >>>
> >> This topic has already been discussed today. in fact, you started
> >> that thread. What was wrong with the answers posted to that thread?
> >>
> >> --
> >> Microsoft MVP - ASP/ASP.NET
> >> Please reply to the newsgroup. This email account is my spam trap so
> >> I don't check it very often. If you must reply off-line, then remove
> >> the "NO SPAM"
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>