Error # = 80040E14

[Michael]

Whenever I try to update or edit a table I get this error message:
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Cannot update '(expression)'; field not updateable.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 23000
NativeError = -1048

I used the dbDebug and copied the SQL string to Access and get an error saying it can't update the ID field. It is an autonumber field and I can't see why it wouldn't be able to change it. Any ideas what is wrong?

[Mark]

Michael,
You are not allowed to edit a AutoNumber Field.
Just put that field in your dbEditHideFlds statement (or leave it out of your dbEditFlds statement)
That should take care of the error message that you are getting.
Mark.

------------
Michael at 9/6/00 10:56:55 AM

Whenever I try to update or edit a table I get this error message:
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Cannot update '(expression)'; field not updateable.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 23000
NativeError = -1048

I used the dbDebug and copied the SQL string to Access and get an error saying it can't update the ID field. It is an autonumber field and I can't see why it wouldn't be able to change it. Any ideas what is wrong?