>>I need a basic tool that can tell me which users are presently connected to our network and which VFP tables they are currently accessing. I know that I can open the Server Manager and access "Users, Shares and In Use" but I need a management tool that I can run from within a [VFP] program.
>
>Most likely you can write such a utility in VFP. An idea to start with would be a "tables" and "users" table. When a user logs on, they create a new record i nthe users table and lock it. When they open a table (maybe DBCEvents can be used here.. thats slick) it does the same thing. When the table is closed, or the user logs off, unlock the record, and mark it as deleted, or "closed" or something.
>
>You may want a process that every ten minutes or so runs through those tables to see if any records are not closed or deleted but unlocked (that means the app did not shut down gracefull).
Another alternative would be to write an application that published a Windows MailSlot and logged messages posted to the mailslot; if each application then created a named mailslot of its own, the first application could examine the running instances of identically named mailslots globally (at least across a domain) to determine which systems were in the application at any given instant. Table opens/closes/locks would be posted as messages to the first app on its mailslot, and you could then show the exact known state of the database and determine which if any systems that held resources had become unavailable by checking for their mailslot's existance.
API calls are neat...