“Operation must use an updateable query” error in MS Access

Whether this answer is universally true or not, I don’t know, but I solved this by altering my query slightly.

Rather than joining a select query to a table and processing it, I changed the select query to create a temporary table. I then used that temporary table to the real table and it all worked perfectly.

Related Posts:

  1. You cannot add or change a record because a related record is required in table ‘table_name’
  2. MS-access reports – The search key was not found in any record – on save
  3. Why do we need “Relationships” between tables at all?
  4. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  5. MS Access error: relationships must be on same number of fields with the same data types
  6. How to SUM two fields within an SQL query
  7. Does VBA contain a comment block syntax?
  8. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  9. “You tried to execute a query that does not include the specified aggregate function”
  10. Cannot join on Memo, OLE, or Hyperlink Object
  11. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  12. Error: “Could Not Find Installable ISAM”
  13. Unrecognized database format’C:\…..\Employees.accdb for Microsoft Access Database File?
  14. no value given for one or more required parameters
  15. How do I count unique items in field in Access query?

Leave a Comment