Help Please!

[chrismartz]

I have a website where you can signup and be able to login to my site. When I confirm the information I get this on my page:


ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/americaspastime/secure/addnewmember.asp, line 49


I have attached the signup, confirm and the page where it adds the user to the database and the database also. If you can help, please do.

[chrismartz]

This is what is on line 49:

RS("Occupation")=theOccupation

[chrismartz]

Alright i got the occupation to be entered but now I am getting this:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]Error in row

/americaspastime/secure/addnewmember.asp, line 55



I can't find anything at microsoft's website on this. On line 55 this is what it reads:

RS.update

[chrismartz]

Alright, I understand what your link means. Thanks. But it used to work with RS.update. I don't understand what I am doing wrong.

[chrismartz]

I am not retarded am I, RS.update does work right?