Solved Operation must use an updatable query - Access 365

NearImpossible

Registered User.
Local time
Yesterday, 22:17
Joined
Jul 12, 2019
Messages
225
I have a database that I made to track my finances, however when I launch it today, I am getting the "Operation must use an updatable query error", with code 2950.

Is anyone else getting this error with Access 365 or ave any suggestions?
 

Attachments

  • Error 2950.PNG
    Error 2950.PNG
    13.5 KB · Views: 185
depending on the query and the joins, it is not updatable.
You cannot update a table if the query has summation on.
 
I have a database that I made to track my finances, however when I launch it today, I am getting the "Operation must use an updatable query error", with code 2950.

Is anyone else getting this error with Access 365 or ave any suggestions?

Never mind, it was because the file is on my network storage and I am running it from a shortcut on my laptop. I enabled Trust Network Locations on the DB itself and its now working.

Guess Microsoft Updates changed my security settings.
 

Users who are viewing this thread

Back
Top Bottom