AcuODBC error - No data found - with update query on MS Access linked table



An attempt was made to modify Vision data by an update query executed on a linked table in MS Access via AcuODBC.  The error returned was:

  Update on linked table xxxx failed.

  [Acucorp, Inc.][AcuODBC Driver][ISAM][No data found (#1).


This error is seen when attempting to update data in a key column.  The data in the key has changed so the SQL processor can no longer locate the row to be updated.  The result is the error "No data found".

Key columns cannot be modified.  The correct way to handle it would be to insert a complete new row with the desired data, including the new key data, and then delete the old row.

Old KB# 3094
Comment List