Forums
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 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 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
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