Total Access Admin is an administrator tool to help you monitor the users going in and out of your Microsoft Access databases (ACCDB and MDB formats).
What are the steps to use the Send Admin Message feature?
In order for your application to support the Send Admin Message feature, your Access application must include some additional functionality. Sample databases are provided (they are copied to the Total Access Admin installation folder) when you install the product. The easiest way to implement this is to import the database objects from the Total Access Admin sample database into your application. Use these steps:
- Open your Access application in MS Access.
- From the Access menu, choose File, Get External Data, Import.
- Browse to your installation directory, and choose the appropriate version of the sample database (there is an example for using ADO as well as DAO).
- Import the following objects:
- Table: FMS_AdminMessage
- Forms: frmStartup, frmAdministrator
- From the Microsoft Access menu, choose Tools, Startup. Set the Display Form to frmStartup.
- Open the code behind any form, and choose Tools, References from the menu. Ensure that Microsoft DAO (or ADO depending upon which version you're using) is selected as a reference.
- Close and re-open your database, and test the Send Admin Message feature from the Total Access Admin Administrator program using these steps:
- Open Total Access Admin Administrator.
- Click the button "Open Database".
- Use the Select Database from to open your production database.
- Under "Send Admin Message", click the Edit Message button to enter the message text that you wish to display to the user.
- Close the message form and put a check in the box for "Enabled".
- In the Refresh settings (top left), set the Interval setting to what you'd like to use. This settings will display the Admin message to your users at the interval settings that you specify here.
- Put a check mark in the box "Enabled."
Once enabled, anybody that has a copy of that database file open will see the message popup at the interval of time that you specified.
Once these steps are complete, the form named frmAdministrator is launched by the form named frmStartup when you open your database. The form frmAdministrator then handles the process required to implement the Send Admin Message functionality for your entire application. This includes the logic that uses a timer to check, at regular intervals, if the Admin Message was sent. There is no need for you to implement any additional code other than what is specified above.