All righty...

Here's another version of the Excel workbook. I've changed the code around a bit to allow you to check if someone is authorized to run, or where their issue is (bad computer or user name). Just an FYI, this will only work on the first record of the database, so if you have multiple users who do use the same PC, we'll need to adjust something again.

To use this, you'll again need to go into Module1 and change the path to the database. While you're there, notice the new constant:
[vba]Public Const AddUserMode As Boolean = True[/vba]
This gives you an easy way to flip the switch on adding new users. When you've got all your users in there, change the True to False, and anyone who has not been added in any way will get a nice message asking them to send you the info for inclusion. Until that time, it will add info for anyone who does not have a match of either computer or username in there.

For anyone who has a computer/user name in the database, if they don't match, they're told to go back to their seat.

Lastly, uncomment the Save line in ThisWorkbook's Workbook_Open module as well. Then save it and give it some tests. You do have Access, right? Just open up to the table, change pieces of either, close the table and reopen the workbook. You don't need to completely close the database.

Have a play, and fire away with the questions. I'm sure you'll have some.