Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi User Table Access
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00233295
Message ID:
00233313
Views:
25
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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform