Query not updateable?!?

[maacky99]

I have a form that is based on a query that has all of the sudden become non-updateable. After searching this site for a while - I found someone who had a similar problem, it was reccomended to check the query the form is based on to see if it could be updated. I did that with mine and the query COULD NOT be updated either.

To the best of my knowledge - nothing has changes with the tables the query is based off of or the query itself.

Any ideas what else to look for?

 

[Pat Hartman]

Did something change with the table definitions? Perhaps a primary key was removed?

 

[freakazeud]

Could be several things here. Only thing that seems weird is that all of the sudden it's not working anymore when it did before. You can look up non updateable query or recordset in access help.
These are a couple possible causes:
1. Improper join
2. Aggregate functions
3. Multiple non-hierarchial 1-many relationships
4. Security
5. No primary key on a linked table.
HTH
Good luck

 

[maacky99]

Thanks for the replies.

There was no primary key removed or changed. I still don't know what caused the problem.

I was able to work around it but I'm still curious as to what happened.