clientuser
Programmer
I have this code:
And have 3 fields on a form named as above and 3 fields in an access database. I can connect to the database with no errors if I only use the last line of rs("email") but when I put in the first and last name fields I get this error:
"ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal."
And it points to the above code to update the db..
Any suggestions?
Code:
If rs.EOF Then
'The email address does not already exist, so add it
rs.AddNew()
rs("FirstName") = Request.Form("txtFirstName")
rs("LastName") = Request.Form("txtLastName")
rs("Email") = Request.Form("txtEmail")
rs.Update()
And have 3 fields on a form named as above and 3 fields in an access database. I can connect to the database with no errors if I only use the last line of rs("email") but when I put in the first and last name fields I get this error:
"ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal."
And it points to the above code to update the db..
Any suggestions?