Ok, failing that, have a form that opens with a timer on it. The timer checks every 1 sec(?) a field within the table.
Asumming that all your users are using the same db, then the admin could have a form that he/she changes the value of this field.
So:
Open the DB.. first form to load will be the the main menu with all controls set to disabled except one command button, called 'Admin'. Clicking on this opens a password protected form. Once the correct password entered, the field is automatically updated..
- Field set to no.. users cant do anything (e.g. controls disabled)
- Field set to yes.. controls enabled..
Means that the admin can kinda 'unlock' the DB remotely. Would require a bit of design work, but the theory is there.
------------------------
Hit any User to continue