How to tell if other users logged in to DB (1 Viewer)

Ally · May 3, 2002

Is there a way, in VBA of telling if another user is logged on, (apart from looking for an .ldb) please?

I have put a compact db command button on a db (instead of on exit of application) as it’s a multi-user application. What I’ve done is put a button on so that the main user can do it at the end of the day when she knows there’s no-one else logged in.

Ideally, I’d put in something along the lines of:

Code:

If NoOtherUsersLoggedIn then
  SendKeys “%TDC”
  Quit

Else
  Quit

EndIf

llkhoutx · May 3, 2002

I've trap the UserID when a user logs onto the database. When a user crash occurs he stays logged in. However, it's works well although is not fool proof.

Ally · May 7, 2002

How do you trap the UserID?

Ally · May 16, 2002

Please ... anyone?

Peter D · May 16, 2002

Here are some links that might help:

Who's logged in: http://www.mvps.org/access/general/gen0034.htm
LDB Viewer: http://www.mvps.org/access/modules/mdl0055.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

Ally · May 20, 2002

Thanks Peter. Unfortunately, the "Who's Logged In" says you must have User Level Security implemented and the LDB viewer is for Acc 2000 - I'm using Acc '97.

For the time being I've got around it, as I found another form that can tell you who's logged in. I've got that to open when the user clicks 'Compact DB' and if there's anyone other than them logged on, they close, if not they can compact.

John.Woody · May 20, 2002

If you've got a form that tells you which other users are logged in you should be able to count the number of users logged in
if > 1 then quit
Else
Compact
quit

HTH
John

Ally · May 20, 2002

We tried doing this already - somewhere along the line it was going wrong. In a msgbox, whether there was 1 user or 5, it told us there was 4 even though on the form it clearly showed who was logged in. Also, if a user logged out during this time, and we clicked refresh, it didn't! Being someone elses code, we haven't quite cracked the problem yet.

How to tell if other users logged in to DB (1 Viewer)

Ally

Registered User.

llkhoutx

Registered User.

Ally

Registered User.

Ally

Registered User.

Peter D

Registered User.

Ally

Registered User.

John.Woody

Registered User.

Ally

Registered User.

Similar threads

Users who are viewing this thread