Is it ok to set Dynaset Inconsisent to all queries and forms?

I just did the abvoe to all my queries and forms and then realized that some of them may not need this to be done, however, I'm not quite sure which is OK if all items have this setting?
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Even doing this will still not make some queries updateable ... depending on the nature of the joins and/or the number of tables.

So ... again, only do this when 1 and 2 apply above.  When you do this, you need to take care which fields are in the query ... such that you are updating the correct field in the desired table, etc.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You only need to do this when:

1) Your query driving the Form's Record Source has more than one table ...


2) The query is not 'updatable' with the normal setting of Dynaset.

Otherwise, there is no reason to do this.

daisypetals313Author Commented:
Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.