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

by

There is no error in the code, but the error is thrown due to the following:

 - Please check whether you have given Read-write permission to MS-Access database file.
 - The Database file where it is stored (say in Folder1) is read-only..?

suppose you are stored the database (MS-Access file) in read only folder, while running your application the connection is not force-fully opened. Hence change the file permission / its containing folder permission like in C:\Program files all most all c drive files been set read-only so changing this permission solves this Problem.

More Related Contents:

  1. How do i add percentage an Access query?
  2. How does one decompile and recompile a database application?
  3. How do you use version control with Access development?
  4. What are the rules governing usage of parenthesis in VBA function calls?
  5. Microsoft Access condense multiple lines in a table
  6. Code to loop through all records in MS Access
  7. Syntax error in insert into statement – what’s the error?
  8. create form to add records in multiple tables
  9. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  10. Why is my query not updateable?
  11. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  12. Is it possible to create a recursive query in Access?
  13. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  14. What is the equivalent of Select Case in Access SQL?
  15. How do I access the selected rows in Access?
  16. insert query with sequential primary key
  17. How do I execute multiple SQL Statements in Access’ Query Editor?
  18. how to show query results in a datasheet in the same form?
  19. Selecting 2 tables from 2 different databases (ACCESS)
  20. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  21. MS Access prepared statements
  22. Linked table ms access 2010 change connection string
  23. How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?
  24. Null values for variables in VBA
  25. Custom row source for combo box in continuous form in Access
  26. MS Access query returning Chinese characters – possible table corruption?
  27. Using a centralized VBA module in multiple Access databases
  28. How to execute a query in ms-access in VBA code?
  29. How to add a menu item to the default right click context menu
  30. Force all users to disconnect from 2010 Access backend database

Leave a Comment