>I need to get exclusive access on a table in my code, but sometimes other users may have this table open. Is there a way I can display in a messagebox which user has the table open, so the person running the app can get them to close out of it?

I found it difficult to determine individual users. What I ended up doing, for maintenance purposes, is the following:

Usually, I do maintenance tasks, that require exclusive access, at midnight, through Scheduled Tasks.

For emergencies, I have the executable check every two minutes (through a Timer, of course) for the existence of a file with a special name, "maintenance.tmp". If this file exists, the application issues the OnQuit() method of the application object. Also, on startup, the application will check for this special file, and close with an error message if the file exists.