>Ron,
>We have a semaphore table that records the user name and date/time for specific forms. The record is then cleared & deleted when the form is closed normally. We check for an existing record each time so if the form was closed abnormally (by power failure or Ctrl-Alt-Del for example) the record is simply overwritten.
>
>A simple grid or browse will show you which users are logged on to the table. Any 'old' records can be deleted after checking their date/time stamp. If your table is always used in one or more forms (not from the command box) this approach would work.
>
>HTH
>Barbara
>
>
>>In a multi-user program, what is the easiest way to tell if a table is opened by another user. I need to use the table from time to time exclusivly to do maintainance and will need to make sure all users are out of the table.
>>
>>Thanks
>>Ron


That idea would work, but you could also have some sort of alert system that logs the user's out of the app databases when you need to do anything exclusively. We have a timer in our application that sees a file on the server and tells the user to exit (the form has a timer on it that closes the application if the user is away from his/her desk).


Wayn