Forums

ASP

This topic is locked

problems inserting record

Posted 21 years ago
1
has voted
21 years ago derek webster posted:
Can anyone help me here

I 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

Reply to this topic