Re: Current User List

See whether http://support.microsoft.com/kb/198755 is what you're looking
for.

(Don't worry that it says "Access 2000": it applies to any ADO connection to
the database)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Sprinks" <Sprinks@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8FDD630-6933-425E-BF1A-A2BABA8BC8D7@xxxxxxxxxxxxxxxx
Litwin, Getz, & Gunderloy, in Access 2002 Enterprise Developer's Handbook
offer a BuildUserList() procedure that lists all current users in the
database, setting an ADODB.Connection variable to the current project:

Set cnn= CurrentProject.Connection

As I do not have the CD and will have to type this sub in manually, I
wondered if anyone knew whether this would find all users connected to the
shared back-end through their local front-ends.

Thanks for any assistance.
Sprinks


.

Relevant Pages