Getting the number of users in the database, others

  • Thread starter Thread starter tbocek
  • Start date Start date
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!
 
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
 
Back
Top