Error Message Detail

[David Starck]

I have a form that uses an Access Database

I run the query and change 1 non-key text field and try to submit and get
the following error message:

The value of an ID key or timestamp has been changed. ID keys and timestamp
columns are automatically generated by the data source and cannot be changed.


Q: Oviously something is getting changed... although I am not sure what it
is. Is there a way to get a better mor complete message that indicates the
row the problem occurs on? Will the script editor work on the for even
though there is no custom scripts?

Any help will be appreciated.

 

[David Starck]

OK more information:

1. Once I ran the query to get the data from the access database I saved
the XML file.
2. I made the change to a non-key field.
3. Again saved the XML file (different name)
4. DIFF'd the two files.

The only difference is the change I made and the filename of the file.

I am assuming this could be an ODBC issue, but not sure how to find out why
it is happening since the error message is so generic and does not help at
all.

Any help/suggestions will be appreciated.

Thanks, Dave