hi Sash,

This message appears, when another user or process has changed the data.

Before saving the dataset Access/Jet looks for the dataset and checks,
if it was changed. It uses the following mechanism:

Table with fields on server:
ID, A, B, ..., Z
ID is the primary key.

Access queries the server for:

  SELECT ID, A, B, ..., Z
  FROM Table
  WHERE ID= AND A= AND B= AND ... AND Z=

It tries to reload the record by comparing _all_ fields of the dataset
with the data on the server, even if it knows the primary key. When the
data has not changed, it returns one record.

Contains the table a field with an unprecise data type, like FLOAT, then
this query can fail due to a  rounding error, because Access/Jet uses a
slightly different rounding than SQL Server. When the record count
returned by this query is 0 then the message appears.

Solution:
Don't use unprecise data types in your primary key fields.
Add a TIMESTAMP field in your table. Then Access/Jet will genereate the
following:

Table
ID, A, B, ..., Z, TS

  SELECT ID, A, B, ..., Z, TS
  FROM Table
  WHERE ID= AND TS=

This will avoid the rounding error and save network bandwith.

mfG
--> stefan <--