Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    41

    Unanswered: Show users logged in to Access 2000 DB

    I manage several Access 2000 DBs and need to know who's logged in before I run certain updates. Courtesy of MS, this link contains the code I started with...

    http://support.microsoft.com/default...b;en-us;198755

    From there, I built a form with a command button to pop up the usernames and hostnames in a msgbox. Works great.

    Next, I'm trying to figure out how to browse for the initial "Data Source=" string. The only options I've found so far are pretty hairy - several pages of code. Does anyone have a simple solution?

  2. #2
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    what do u mean browse data source? you mean you want to do this check user thing three times in three different places rite?

  3. #3
    Join Date
    Mar 2004
    Posts
    41
    No. I want the Explorer-like window... whatever you call it... that most programs associate with Save/Open. To allow the user to locate the mdb to open.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •