>>>>>This produces:
>>>>>Error Type:
>>>>>Response object, ASP 0185 (0x8002000E)
>>>>>A default property was not found for the object.
>>>>>/contactmanager/edituser.asp
>>>>
>>>>If you go back one step, remove execscript and just try insert command (no return), would it work?
>>>
>>>Yes, the insert by itself works fine.
>>
>>Can you create a SP in your database that would return the inserted value (GETAUTOINC()) and try to execute this SP instead of the direct insert?
>
>Probably, that's what Cetin recommended. But wouldn't know how to return the value to ASP.

Here's a SP Example lifted from the web:

** sp_insert 
PARAMETERS value 
SET NULL OFF 
INSERT INTO table1 (field1) VALUES (m.value) 
CREATE CURSOR result (result i) 
INSERT INTO result VALUES (GetAutoincValue()) 
RETURN SETRESULTSET("result")