Writing to database

[exodus300]

I'm teaching myself how to use MSAccess databases with asp/PWS. I made a (small) DB in access, and can successfully read it into a HTML table. But I tried adding records using the example in the PWS documentation, but I get the following error:

ADODB.Recordset error '800a0bb9' 

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 

/xxxxxxxx.asp, line 79

Line 79 is as follows:

rsList.LockType = adLockOptimistic

 

[gacaccia]

how are you creating the recordset? are you trying to set the lock type before or after the recordset is opened? i believe the lock type cannot be changed once the recordset is open.

glenn

 

[cuedog]

I used to have this error also. It has to do with what type of data you are entering in the database and what datatype you have your fields in your database registered as (text,memo,numeric,object). Check this. What type of data are you inserting, and what datatype is your field?