---------------------------------------------- That'll Do IT - Database Solutions ShowUserRoster version 3.4 Copyright (C) Bill Mosca 2008 ---------------------------------------------- Thanks for trying That'll Do IT - Database Solutions ShowUserRoster for MS Access MDB, MDE and MDA files. This utility allows you: - to see who is in your database. - Lock out new logins. - Send a message to all users in the database to please log out. This Add-in is designed to be used in the back end of a split database. Included in the zip file is a sample database that shows you how to get the messaging to work. To make everything work: 1) The table AdminMessage should be in the back end database where you will be using the Add-in. All Front Ends should be linked to it. 2) The Front End should have the two forms frmAdminMsg, frmInactiveShutDown and a startup form. Your Startup form can be anything you want. Just be sure to copy the Form_Load code from the sample into your startup form's Form_Open or Form_Load event so the log out form will load as hidden right away. Warning! Don't change anything about frmAdminMsg, frmInactiveShutDown or the AdminMessage table. If you do, you won't be able to use the messaging and inactive shutdown. **********Installation********** To ensure that the add-in works properly, unzip ShowUserRoster_ver32.zip to your C: drive. This will place ShowUsers in the folder, C:\Program Files\ThatllDoIT. If you don't unzip directly to your C: drive, the registry key will be wrong and the Add-in will not load. If you must put the folder in another location, I can send you a customized version. If you have installed a previous version of ShowUserRoster.mda, you will have to delete it from Microsoft's default Add-in folder for Access. Depending in your operating system, there are a variety of places that might be. With Windows XP, it's C:\Documents and Settings\\Application Data\Microsoft\AddIns. Note to Vista users: You will probably have to set this folder as Trusted. I have not tried this Add-in on a Vista operating system so there might be some problems with it. I would appreciate it if you pass these issues on to me so I can adjust either the installation or the Add-in itself in future versions. Open any database in Access and click on Tools/Add-ins/Add-in Manager. Click on Add New. Browse to the folder and file at C:\Program Files\ThatllDoIT\ShowUserRoster.mda Click OK. This will copy the MDA file to Microsoft's default Add-in folder for Access. Depending in your operating system, there are a variety of places that might be. With Windows XP, it's C:\Documents and Settings\\Application Data\Microsoft\AddIns. You have to do this only once. ********************************** To use the ShowUserRoster add-in for any database, click Tools/ Add-ins/Database User Roster. *Click Show Users to see who is in the database. *Check the auto refresh to refresh the list every 10 seconds. *Click Secure for Maintenance to lock out any more users. There is a sample database included with this add-in that shows how to implement the message sending feature. You must sset up your database with an AdminMessage table and include the form named "frmAdminMsg" found in the sample. *Click Send Log Out Request to send a message to all current users to log out. Check Edit message if you want to change the default message. *Click Cancel Message to turn off request. Note: The form must stay open to keep the database locked. **********History********** Version 3.4 Updated company info, changed color scheme. Version 3.3 Fixed a bug in password code. Version 3.2 Added method for turning off message. Fixed bugs in sample database. Version 3.1 Added optional Alert pop-up form that tells you when the database is ready to be modified (all other users are logged out). Version 3.0 Added ability to send log out message to users. Version 2.0 Changed the utility to an Add-in ShowUserRoster is Freeware and may be distributed as is. It may not be sold. If you have any questions, feedback or if you find any bugs please contact me at wrmosca@thatlldoit.com or go to http://www.thatlldoit.com and navigate to Contact page. If you wish to be notified as updates are made available email me at the above address and I will send you an email when the latest version becomes available. I promise to never sell or give your email address to anyone. Not even your mother. Requirements: Access 2000 or higher