VB Forum / Database Access / September 2005

VB6, SP6 - using an ODBC driver for dbase tables, clientside cursor

I have an application that gives a ' 2147217887 - Multistep operation
generated errors' error. This does not seem to have any hard cause and the
offending operation can be repeated without problems. The problem seems to
be getting worse and is now occuring about once a day. It can appear in
various places but seems to be always when an update is occuring.

I have identified one area where it has occured and the code is given below.

Public Sub NextPlRunNos(InPLRunNos)
 With plSysRs
   .Requery
   .MoveFirst
   InPLRunNos = !Pl_lstrun
   If Not IsNull(InPLRunNos) Then InPLRunNos = Val(!Pl_lstrun) + 1
   If IsNull(InPLRunNos) Then InPLRunNos = 1
   !Pl_lstrun = InPLRunNos
   .Update
   .Move (0)
 End With
End Sub

I cannot seem to find any reference to this error . It seems obvious that I
am doing something incorrectly. Can anybody point me in the right direction
to tackle this.

Many Thanks

Alan Hood