Solved Operation must use an updatable query - Access 365 (1 Viewer)

NearImpossible

Registered User.
Local time
Today, 10:07
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: 151

Ranman256

Well-known member
Local time
Today, 11:07
Joined
Apr 9, 2015
Messages
4,339
depending on the query and the joins, it is not updatable.
You cannot update a table if the query has summation on.
 

NearImpossible

Registered User.
Local time
Today, 10:07
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?

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

Top Bottom