>This sounds like a situation that requires a more rigorous synchronization mechanism, such as obtaining a lock on a shared table or record. Otherwise, you could possible use one of the WinAPI Event facilities, as in examples related to enforcing single-instance apps.
Yes, this is what I thought for a while. However, for this, I try to stay away from table use. As others have said, probably the best way would be to use the TRY/CATCH approach. Thanks