Updateable query rules

[gg80]

Is there some site that publishes rules for making and updateable query? I sometimes get the not updateable situation when there seems to be no logic for it-very frustrating.

[pbaldy]

Several:

http://allenbrowne.com/ser-61.html

Updateable Queries

[gg80]

I sometimes create queries that don't allow any fields to be changed, seemingly for no logical reason. Is there a site that will give me rules for determining when a query is udateable?

[jzwp11]

This site has a list of what makes a query un-updateable.

[RuralGuy]

...as does this one: http://allenbrowne.com/ser-61.html

[pbaldy]

Were the two I gave you earlier not enough?

https://www.accessforums.net/queries...les-10313.html

[gg80]

Thanks much-I goofed on posting-didn't think that the first one made the post. Thanks again, much appreciated.

[RuralGuy]

I put the two threads together for everyone. Much easier to understand. You can always use the Report Post button on the top right of each post to let me know about a problem. It includes a link to the post for me so it make it easier to find stuff.