Operation must use an updatable query. (Error 3073) Microsoft Access

by

Since Jet 4, all queries that have a join to a SQL statement that summarizes data will be non-updatable. You aren’t using a JOIN, but the WHERE clause is exactly equivalent to a join, and thus, the Jet query optimizer treats it the same way it treats a join.

I’m afraid you’re out of luck without a temp table, though maybe somebody with greater Jet SQL knowledge than I can come up with a workaround.

BTW, it might have been updatable in Jet 3.5 (Access 97), as a whole lot of queries were updatable then that became non-updatable when upgraded to Jet 4.

—

More Related Contents:

  1. Combine values from related rows into a single concatenated string value
  2. What are the rules governing usage of parenthesis in VBA function calls?
  3. Autonumber value of last inserted row – MS Access / VBA
  4. How to get random record from MS Access database
  5. create form to add records in multiple tables
  6. Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
  7. Running Microsoft Access as a Scheduled Task
  8. How to diagnose MS access crashes
  9. “Operation must use an updateable query” error in MS Access
  10. How to restart counting from 1 after erasing table in MS Access?
  11. Equivalent cURL in VBA?
  12. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  13. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  14. MS Access trigger?
  15. Insert SQL command with Datetime in MS-Access
  16. Is MS Access (JET) suitable for multiuser access?
  17. VBA procedure to import csv file into access
  18. How to select top 10 in Access query?
  19. ConcatRelated() in Access, using two keys
  20. Concatenating multiple rows into single line in MS Access [duplicate]
  21. How to write Case Sensitive Query for MS Access?
  22. Transform multiple rows into columns with unique key
  23. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  24. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  25. Custom row source for combo box in continuous form in Access
  26. VBA – Run Time Error 3271 using DAO object
  27. Working with multiple programmers on MS Access
  28. Trouble with InputBoxes
  29. Get Name of Current VBA Function
  30. How to extract the schema of an Access (.mdb) database?

Leave a Comment