>Hi.
>I have a table that could be updated by
>more than one diferent application in
>diferents client computers. Question:
>Is there a way to know if an application
>is using a table or database before
>you open it in another application?
I think you should program for shared access (SET EXCLUSIVE OFF), and use optimistic buffering. In this case, more than one person or application can access the table at the same time.
Possible conflicts would happen at the record-level. See my article on buffering, if these details are new for you (
http://www.levelextreme.com/Magazine/July2002/Page6.asp).
HTH,
Hilmar.
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)