[dba-VB] Multiple Step Operation Generatted Errors

Arthur Fuller artful at rogers.com
Wed Dec 10 13:47:33 CST 2003


Another reason for this error is that you are trying to update a view
tbat is not updatable. The multiple steps to which the error refers are
a delete and an insert. It tries to delete the row then re-insert it
with the new values, and errors out.

Arthur

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gary Ray
Sent: Wednesday, December 10, 2003 6:24 AM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Multiple Step Operation Generatted Errors


In my experience this error typically occurs when you are trying to add
data to a recordset that is to large for the designated field.  I would
first check the size of any character fields and see if the data you are
sending to it is too large.
 
I am sure there are other reasons for this error, but this is the one I
have seen the most.
 
 
Gary Ray - Application Developer
Workforce Information Systems R & D
E-Mail gray at utah.gov

>>> martyconnelly at shaw.ca 12/09/03 11:40PM >>>
You might check what version of Jet you are using; check properties 
msjet40.dll for version no.
then go to 
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion
/dllinfo.asp&fp=1 
and fill in the blanks. to find out jet release number from dll version 
number
Should be using Jet version 7 or 8 depending on OS
Just a guess

paul.hartland at fsmail.net wrote:

>To all,
>I have an application that is giving me Multiple Step Operation 
>Generatted Errors, is there any particular reason that this error 
>occurs.  We are linking to an Access XP database, and the recordsource 
>for the form is a command from the DataEnvironment.  Has anyone else 
>come across this error, if so, why does this happen. Thanks in advance 
>for all your help. Paul Hartland Freeserve AnyTime - HALF PRICE for the

>first 3 months - Save £7.50 a month www.freeserve.com/anytime
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/dba-vb 
http://www.databaseadvisors.com 



_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com





More information about the dba-VB mailing list