Operation must use an updatable query. (Error 3073)

See Also

You tried to run, open, or modify a query that is not updatable.

Possible causes:

• You attempted to run a query that tried to update a field that cannot be updated. For example, you may have created the query in such a way that you tried to update a field on the one side of a one-to-many relationship.
  
  
• You tried to use the obsolete OpenQueryDef method on a query that is in a database opened for read-only access.

  The database is read-only for one of the following reasons:

  • You used the OpenDatabase method and opened the database for read-only access.
    
    
  • The database file has been defined as read-only in your network operating system.
    
    
  • In a network environment, you do not have write privileges for the database file.

  Close the database, resolve the read-only condition, and then reopen it for read/write access.

• You do not have permission to make changes to the query. To change your permission assignments, see your system administrator or the query's creator.