Ally
Registered User.
- Local time
- Today, 05:04
- Joined
- Sep 18, 2001
- Messages
- 617
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:
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