Method 'Movenext' of object '_Recordset' failed

Last Published: April 25, 2020

Error Message

Looping through a database schema ADO recordset using the ESRI OLE DB provider returns "Method 'Movenext' of object '_Recordset' failed" when attempting to move to the next item in the recordset.


If the ADO connection has been made to an ArcSDE Geodatabase which includes custom COM objects and the class extensions for those objects have not been installed on the local machine, the movenext method on the database schema rowset (recordset) will fail when these objects are encountered.

Solution or Workaround

If it is not feasible to install the custom object extensions locally, trap for the error and resume the loop through the recordset.

On Error GoTo Err:
Do Until adors.EOF
Exit Sub

MsgBox Err.Number & Err.Description, vbExclamation
Resume next
End Sub

Article ID:000002585

  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options