Coder:Resources
Candace:Tripp is dedicated to providing links to
.NET,
Visual Basic,
MS Access and
Web
resources and free example
projects and databases to
download for all coders, noobs to experts.
Good luck and I hope you find my site useful!
Demo of the Day
Type/Version:
MS Access 2000/2002
Demo:
Check User Open Mode/Number of Current Users
Description:
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.