Form

[tjm77]

I have an online form that should write to a Access table, but I keep getting the following error:

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

/requests/request.asp, line 20

Line 20 looks like this:

oRSs.open "Table1", "DSN=Requests", adOpenDynamic, adLockPessimistic

Need some help!

 

[sacview]

You need to include more information. Most likely this is coming from your SQL select or insert statement. Or your did not define adOpenDynamic and adLockPessimistic.

Hope this helps

 

[sjf]

If you don't have adovbs.inc setup as an include it will give you this error each time (as adOpenDynamic and adLockPessimistic have not been defined).

Also check your SQL statement is correct in it's references to database fields.
sjf