Coding to know if table is being updated.

D

Den

Hi,

I have two access programs that reference the same table in SQL Server 2000.
The problem occurs when both programs try to edit table at the same time.
The programs crash.
Is there any function or methond that can be used to see if the table is
being edited and if so to wait until table is free to edit. Currently I am
access the table through DAO.Recordset. I tried RS.LockEdits but since they
are two different programs access the table it does not work.

Any suggestion would be great. Thanks
 
Top