MS Access Error: Run-time error ‘3073’: Operation must use an updateable query.

Background: While performing an update operation this morning to a table in the application the “MS Access Error: Run-time error ‘3073’ “is showing up.

Workaround:

Upon investigating it seems that the underlying table where update used to be executed is missing “Primary Key” constraint.

Resolution:

As using Oracle as backend database declaring the ID column(the PK candidate) of the table as “Primary Key” solved the issue.

ALTER TABLE EBIZ.TEST ADD (
 CONSTRAINT TEST_PK
 PRIMARY KEY
 (ID)
 USING INDEX EBIZ.TEST_PK
 ENABLE VALIDATE);

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.