Jack,
I have two ways to accomplish that. The easiest is to have a table with two fields, InUse and CurrentUser. When a user opens the database and the first form opens, you have an on open event that verifies that InUse is set to false, otherwise it triggers a message box and a close. I store...