Forums
This topic is locked
problems inserting record
Posted 21 years ago
1
has voted
21 years ago derek webster posted:
Can anyone help me hereI can pull data from my db no problem but I can't update or insert any records. I get this error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Cannot update 'ProductID'; field not updateable.
/websters_ii/update.asp, line 111
any ideas?
Replies
Replied 21 years ago
21 years ago Brad Hitt replied:
First of all, I am assuming that ProductID is a primary Key. With that assumption, you can not edit the column designated as a primary key. If you are trying to insert a new record, then do not try to Insert into the primary Key column. That cloumn will update automatically.
Replied 21 years ago
21 years ago derek webster replied:
You've just made my day!! - this is my 1st week working with MX so forgive my stupidity.
You assumtion was spot on.
Thank you very much. I'm sure I'll be back on in a day or two with another simple problem
You assumtion was spot on.
Thank you very much. I'm sure I'll be back on in a day or two with another simple problem