ERROR

No update operation allowed without Unique Id

Last Published: April 25, 2020

Error Message

Listing related items in an Access table produces:

No update operation allowed without Unique Id.

Cause

The Access table needs to have a primary key specified.

Solution or Workaround



Open the table in Access and specify the relate column as a primary key.

Open the table you wish to work with in design view and select the field you wish to designate as the primary key field. The unique index is created automatically.

[O-Image] Adding a primary key, unique index, to an Access table

Article ID:000003682

Software:
  • Legacy Products
  • 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