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

Posted on 2009-04-20
Last Modified: 2013-11-29
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?
Question by:daisypetals313
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    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.

    LVL 75

    Accepted Solution

    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.


    Author Closing Comment

    Thank you!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now