Viewing users in Access

[Guest]

All,

Is there a feature in Access 2003 running on XP Pro that allows you to view
which users are using the database at any given time? The administrators of
the database we created using Access would like to view which users are
logged into it. This is a shared DB one a shared network drive.

Thanks in advance!

SS

 

['69 Camaro]

Hi, Scott.

Access doesn't provide such a feature, but Microsoft's LDB Viewer is such a
tool which can be used to view the users of any Access database on the
network. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web
page:

http://www.Access.QBuilt.com/html/links.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Joseph Meehan]

All,

Is there a feature in Access 2003 running on XP Pro that allows you
to view which users are using the database at any given time? The
administrators of the database we created using Access would like to
view which users are logged into it. This is a shared DB one a
shared network drive.

Thanks in advance!

SS

Sure. The YOURDBFFILENAME.LDB is a file created when an Access database
is opened and contains various information including a list of everyone
logged onto the database.

Microsoft offers several utilities to view the information. I believe
they are all free for the download. You can use the stand alone programs or
it is possible to access the information from within the program if needed.
I have only used their stand alone program and it worked fine for my needs.

 

[Guest]

Damn, sorry to hear that. Thanks '69!

Scott

Hi, Scott.

Access doesn't provide such a feature, but Microsoft's LDB Viewer is such a
tool which can be used to view the users of any Access database on the
network. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web
page:

http://www.Access.QBuilt.com/html/links.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

['69 Camaro]

Hi. Scott.

If the LDB Viewer tool doesn't suit the Administrator's needs, then an
Access developer could write some code in the Access database to execute
that would retrieve and display the database user information for the
Administrators. Sample code for this task in Access 2002 and 2003 is
available on this Web page (with a link to the Access 2000 version):

http://support.microsoft.com/default.aspx?id=285822

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

This actually works very well. Thanks again '69!

SS