Error 2950

[jcsuarez]

I´m using ACCESS 2003, as well as ACCESS 2010. In both of them, I´m sometimes getting an Error Message stating "Error 2950: Query is not updatable", a message that repeats itself for between 5 to 30 times in a row. It´s very annoying. I have to close the form that I´m working with, re-open it and nothing will happen for a while.
After a while, the problem will repeat itself, but there is no update query involved as far as I know.
Can anybody help me please?

 

[Ranman256]

depending on the nature of your query,
its possible its NOT updateable due to the joins.

 

[lorein0688]

To fix the try to enable the database, and to enable the current session of the database you have to follow these steps:
1. On the Message Bar, click Options.
2. In the Microsoft Office Security Options dialog box, select Enable this content, and then hit OK.
Note: Follow these steps each and every time while opening the database.
This might help you or make use of the Access Repair tool.
hope this works...

 

[jcsuarez]

Thanks a lot, Lorein0688: I´ll try your advice very soon, and I´ll let you know how it worked.