Error: Too few parameters. Expected 2

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.