Unable to update record.  Operation must use an updateable query...

Problem

You get this error when running your application:

Unable to update record.  Operation must use an updateable query…

This error is generally caused when the folder containing your application’s Microsoft Access database does not have sufficient permissions to insert (write) records.  This can occur when your database is in a separate folder from your application.

Solution

Add sufficient access permissions to the folder containing your Microsoft Access database necessary for records to be updated and inserted.

See Also

Part VII:  Troubleshooting Applications

Application Will Not Run

Application Runs But No Data is Displayed

Application Error Messages