Learn how to a build a cloud-first strategyRegister Now


What is Dynaset Inconsistent?

Posted on 2009-04-20
Medium Priority
Last Modified: 2013-11-29
What exactly does setting to dynaset inconsistent do?  I think I remember reading something about having to use this on forms that are based on a query of multiple forms.  Is that correct?
Question by:daisypetals313
  • 4
  • 2
LVL 75
ID: 24189752
"Is that correct?  "

Yes, exactly.

From the Help File:

"Dynaset (Inconsistent Updates) 1 All tables and controls bound to their fields can be edited. "


LVL 75
ID: 24189760
This is both a Form property (on the Form property sheet - Data tab) and also a Query property - set in query design view.


Author Comment

ID: 24189790
Is it necessary for me to set this in both the queries and the forms seperately or just on the forms?
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 24189811
Both ... if the query is the record source for the form.


Author Closing Comment

ID: 31572525
Thanks!  I have set both queries and forms to dynaset inconsistent.
LVL 58
ID: 24193188
While that is the affect of inconsistent updates, that really is not the definition of it as it applies to recordsets in general and not just in forms.
Consistent vs inconsistent updates only come into play when you have a recordset based on more then one table.  Normally, JET allows changes only to the many side of a join.  That's a consistent update.  To allow for updates to both sides of the join, you need to use an inconsistent update.  You really need to understand why you need to do that as doing so allows you violate relationships between the tables.
The only exception to that is if you've turned on Referential Integrity and cascading updates.  In that case, consistent vs inconsistent doesn't matter because even if you change the key on the one side, the many side will get updated anyway.
JET is unique in this regard. Most OLEDB providers don't support inconsistent updates.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

810 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