Re: Error 3265 mystery error


When I move the call to the Update method of the target recordset inside the
Field iteration like the following:

For Each objFld In rstSrc.Fields
rstTrg.Fields(objFld.Name).Value = objFld.Value
Call rstTrg.Update
Next objFld

my 3265 errors go away, and my app runs happily through to the finish.


It may go away but this looks like a hack to me.
I would not be happy with this.
I would digging somewhat deeper to find out why the former does not work.

Stephen Howe


.