• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

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 ones...is is OK if all items have this setting?
0
daisypetals313
Asked:
daisypetals313
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You only need to do this when:

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

AND

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

Otherwise, there is no reason to do this.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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.

mx
0
 
daisypetals313Author Commented:
Thank you!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now