Getting the number of users in the database, others

T

tbocek

Hi, is there an easy way to tell how many users are
currently connected to the Access 2003 database? Ideally
I'd like a function that just returns the number of
users. I know that the LDB file stores such information,
but I have no idea how to get it out of the file.

Also, on an unrelated note, is there a way to open a
specific word document by clicking a button in Access? (I
know there's a wizard to create a button that just opens
word, but I don't know how to get it to open a specific
document.) I have a help document that I'd like to be
able to open from an Access form.

Any help would be appreciated. Thanks in advance!
 
P

Pete Sheridan

Hi tbocek,

The following url will take you to an old knowledge base
article that allowed you to download a file named 'Jet
Utilities'

http://support.microsoft.com/default.aspx?scid=kb;en-
us;176670&Product=acc#appliesto


I use the 'LDB Viewer' to check who is using the Access
Front-End that is used in our office. The LDB Viewer
isn't guaranteed to work with Access 2003 but I haven't
had any problems with it and it sure helps.

Pete
 
Top