>I am trying to simply set up a messagebox to tell other users that administrators are currently working on the database rather than having that error message come up to tell them that access is denied. Is there simply a way to set up an if statement at the beginning of the start code to check to see if exclusive is set, then send out a message box? Or is there another way that you know of to do this?
>
>I have tried to set up an m variable (i.e. flag) in this update code that would go to true when it starts and false when it ends. I then set an if statement in the start code to check to see if it is set to true or false. However, it does not recognize the public m variable that the other program has set. Any thoughts?
How about TRY...CATCH? After all, several things might go wrong when trying to access anything external to your program.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
