we are using ACCESS 97 as front end and SQL Server 6.5 as back end.
When more than one workstation is running our programm these
workstations are more and more often in a "deadlock" state, it seems
they are locking each other out. When this occurs, we are not able to
access the locked server table directly by ISQL/W, too.
Mostly, we access the tables by opening Dynasets by OpenRecordset,
some recordsets are kept globaly open. Actually, the "deadlcok" occurs
when one stattion tries to update a modified recodset to the data
source. My ACCESS doc tells me that ACCESS is not locking linked
tables at all, so _who_ does all this locking ???
Is there any good documentation which tells me exactly what happens
inside ACCESS and SQL Server when ACCESS accesses linked tables ?
Many thanks in advance for your help,