Viewing users in Access

S

scottshiller

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
 
6

'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.)
 
S

scottshiller

Damn, sorry to hear that. Thanks '69!

Scott


'69 Camaro said:
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.)
 
6

'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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top