Demo of the Day

MS Access 97
Check User Open Mode/Number of Current Users
This database demonstrates how to check for open mode (shared or exclusive) and the number of current users. The Check Open Mode button tells your user what mode he/she has opened the database in. If their open mode is "exclusive", they get an error message and exit from the database. On exit, their open mode is globally changed to "shared". This is useful if you have a multiuser database but are not using security. The Check Number of Current Users button tells your user if they are the only current user of the database regardless of their open mode. Acknowledgement: The source for Msldbusr.dll and frmLDBUser is The Access 97 Developer's Handbook by Sybex.