Too few parameters. Expected 2

Last Published: April 25, 2020

Error Message

Using a Microsoft Access database table as the address table when geocoding results in the following error:

"There was an error trying to process this table.
General function failure [table name]
Too few parameters. Expected 2."


There is a field in the table defined as a memo field.

Solution or Workaround

Using Microsoft Access, either convert the memo field to a text field, or remove the memo field from the table.

The text field only holds 255 characters, any characters beyond 255 will be lost. If the the memo field contains more than 255 characters, create a lookup table to hold the information in the memo field that can be joined to the geocoding result.

Fields of type XML can be used to store strings longer than 255 characters.

Article ID:000006211

  • ArcMap 8 x
  • ArcMap 9 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