Cannot preview Access 2000 tables that include MEMO fields via an OLE DB connection

Last Published: April 25, 2020


Tables that include MEMO fields cannot be accessed in ArcGIS. The tables are listed under the OLE DB connection item in the TOC but the data cannot be previewed.


This is a known issue (data type conversion error) when using the Microsoft OLE DB provider for ODBC sources to make the connection to the Access 2000 file.

Solution or Workaround

Use the Microsoft Jet 4.0 OLE DB provider to make the connection.

Article ID:000002627

  • 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