Provider error ’80020005’

Howdy,

I have an Access database hosted on uplinkearth, and an ASP page that accepts data from a form on an html page.  When I hit submit, I get this:

Provider error '80020005'

Type mismatch.

/clientinput.asp, line 20

Line 20 of my code is:

rsAddRecord.Open strSQL, "Client", adoCon

If anybody has any ideas of what this might be, I'd appreciate the help.  All of my data fields are specified as text, so its not what I thought it might be.  I'm stuck.

Thanks for the help!  If anybody wants the file, its www.angelcaregiving.com/asclientreg.html and the ASP file is www.angelcaregiving.com/clientinput.asp

rsAddRecord.Open strSQL, "Client", adoCon

I don't understand the "Client" bit. To open a recordset all you need is 2 properties, the SQL statement and the active DB connection.

Try rsAddRecord.Open strSQL,adoCon and see if it works.