[AccessD] Muliple-step operation error - VB6 FE SQL BE

To all,

I have a Visual Basic 6 form which is connected to a SQL Server 7.0 database using an ADO control, all of the fields are either text or date with the exception of one, which is numeric.  If I enter a numeric value in this everything is fine, but if I enter text or delete the contents and then try to save the recordset I get the following error message :

Multiple-step operation generated errors.  Check each status value.

Anyone have any ideas on why this happens ?

Paul 


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.