80040e14 error, field not updateable, Why not?

[markvan]

I am filtering records in the recordset by the field "MeetingID"
and wish to be able to update the other fields in this recordset. When I try to update, it gives me the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Cannot update 'MeetingID'; field not updateable.

/meetingreport.asp, line 89

Why is the field not updateable?
Or how do I bypass it as it is only the other fields I need to update not the "MeetingID"?

PS. The recordset contains no fields with names that are reserved, so the syntax situation seems OK to me.

Thanks in Advance!

 

[Cheech]

Your sql should read something like:

UPDATE tblMeetings SET column1 = "value" WHERE MeetingID = 1

the error you are getting seems to indicate that your trying to update a unique reference field

Cheech Live long and make your kids suffer..

 

[markvan]

Thanks Cheech

I didn't use your SQL, but you got me on the right track by saying I was trying to update the primary field/unique reference field.

I resolved my problem by removing the field "MeetingID" from the server behaviour Update, and leaving it in the recordset. Just thought I'ld note it here in case someone else struggles on this like I did.

PS. Give my regards the Chong next time you see him! X-)

 

[Cheech]

He's in the bus at the mo lol Live long and make your kids suffer..