By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,408 Members | 1,796 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,408 IT Pros & Developers. It's quick & easy.

Determining current active users in Access 97

P: n/a
I know that the .ldb file should show the users currently logged into a
database.

However, when a user logs out I cannot detect any change in the file.

I must be missing something as PSPad pops up a message that the file has
changed (maybe it is just detecting the time-stamp but that means
something **has** changed)

However, when I compare a hex print of the before and after file I
cannot see that anything has changed. The details of the logged out
user still seems identical to what it was when he was logged in.

I know the format of the file is undocumented, but could anyone help
with decoding it.

I want to write a function that will determine (in A97) how many
**active** users are currently logged in.

Thanks
--
Les Desser
(The Reply-to address IS valid)
Nov 9 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Wed, 8 Nov 2006 23:58:46 +0000, Les Desser
<Ne*******@dessergroup.comwrote:

The format may be undocumented, but not inaccessible. Search for
MSLDBUSR.DLL and LdbViewer.

-Tom.

>I know that the .ldb file should show the users currently logged into a
database.

However, when a user logs out I cannot detect any change in the file.

I must be missing something as PSPad pops up a message that the file has
changed (maybe it is just detecting the time-stamp but that means
something **has** changed)

However, when I compare a hex print of the before and after file I
cannot see that anything has changed. The details of the logged out
user still seems identical to what it was when he was logged in.

I know the format of the file is undocumented, but could anyone help
with decoding it.

I want to write a function that will determine (in A97) how many
**active** users are currently logged in.

Thanks
Nov 9 '06 #2

P: n/a
In article <7a********************************@4ax.com>, Tom van
Stiphout <no*************@cox.netThu, 9 Nov 2006 07:05:39 writes
>The format may be undocumented, but not inaccessible. Search for
MSLDBUSR.DLL and LdbViewer.
Thanks.

Seems like the documentation says it is A2K form.

Is there something for A97 or is the form adaptable for A97 use?
--
Les Desser
(The Reply-to address IS valid)
Nov 9 '06 #3

P: n/a
I do not know if this app (form and module) will work with 97 but it
would be worth a try.

Try this link: http://www.mvps.org/access/modules/mdl0055.htm

it has a small access app that looks at the ldb file and will tell you
all of the users that are logged into mdb that you reference.
really neat and small, and the code for the form can be imported into
any app that you want or run standalone out of this app. With that you
may be able to tell what machine is actually holding open the ldb file
without having to try to guess.
Ron

Nov 9 '06 #4

P: n/a
In article <11**********************@i42g2000cwa.googlegroups .com>,
Ron2006 <ro******@hotmail.comThu, 9 Nov 2006 11:31:09 writes
>Try this link: http://www.mvps.org/access/modules/mdl0055.htm

it has a small access app that looks at the ldb file and will tell you
all of the users that are logged into mdb that you reference.
I think that is the same/similar to a link from a previous poster.

The page says the form is A2K but the MS article it links to is in fact
talking about A97 - so I hope the ldb file format is the same for both.

I need this for A97 but have A2K installed so I will look at the code
and see if I can use it in A97.

Thank you.
--
Les Desser
(The Reply-to address IS valid)
Nov 10 '06 #5

P: n/a
In article <11**********************@i42g2000cwa.googlegroups .com>,
Ron2006 <ro******@hotmail.comThu, 9 Nov 2006 11:31:09 writes
>Try this link: http://www.mvps.org/access/modules/mdl0055.htm

it has a small access app that looks at the ldb file and will tell you
all of the users that are logged into mdb that you reference.
The link leads to two different forms.

Via a link - one is "Who's logged on for Access 97 (30K)" at
<http://www.groupacg.com/while the other on the original page uses
msldbusr.dll.

The first in fact I discovered some years back, but in fact does not
work properly. The problem seems to be that when a user logs out, its
ldb file entry does **not** get removed so the forms still reports that
user as logged in.

Has anyone used the msldbusr.dll method in A97?
--
Les Desser
(The Reply-to address IS valid)
Nov 12 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.