Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

updating access db

Status
Not open for further replies.

clientuser

Programmer
Apr 18, 2001
296
0
0
US
I have this code:

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?
 
Nevermind...

I didnt select those fields in my SQL query beforehand...

silly me...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top