Forums

ASP

This topic is locked

problems inserting record

Posted 11 Jun 2003 20:07:19
1
has voted
11 Jun 2003 20:07:19 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 11 Jun 2003 22:03:21
11 Jun 2003 22:03:21 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 11 Jun 2003 23:17:25
11 Jun 2003 23:17:25 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