G
Guest
I have a database system with a SQL back end and a Access front end ( 2002
sp2).
I have a form based on a simple query. I have the record set type set to
Dynaset (inconsistant updates). Operators use this to enter manfacturing
data. It works well except occasionally there is a record locking problem.
It only affects one field, a memo and it isn;t all records only a few. When
data is entered I get an error satting another operator has changed the data.
Copy or Drop changes. This only happens with the one field all others are
fine. It also seems to happen to one operator.
I tried to reporduce this error with other records by openning two session
and editing the same record in both. This produce no errors. I've checked
the operator SQL permissions.
Any ideas on what could cause this isolated error?
sp2).
I have a form based on a simple query. I have the record set type set to
Dynaset (inconsistant updates). Operators use this to enter manfacturing
data. It works well except occasionally there is a record locking problem.
It only affects one field, a memo and it isn;t all records only a few. When
data is entered I get an error satting another operator has changed the data.
Copy or Drop changes. This only happens with the one field all others are
fine. It also seems to happen to one operator.
I tried to reporduce this error with other records by openning two session
and editing the same record in both. This produce no errors. I've checked
the operator SQL permissions.
Any ideas on what could cause this isolated error?