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

What is Dynaset Inconsistent?

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?
0
daisypetals313
Asked:
daisypetals313
  • 4
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Is that correct?  "

Yes, exactly.

From the Help File:

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

mx

0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
This is both a Form property (on the Form property sheet - Data tab) and also a Query property - set in query design view.

mx
0
 
daisypetals313Author Commented:
Is it necessary for me to set this in both the queries and the forms seperately or just on the forms?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Both ... if the query is the record source for the form.

mx
0
 
daisypetals313Author Commented:
Thanks!  I have set both queries and forms to dynaset inconsistent.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
JimD.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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