Question about form's Recordset Type property

L

lttruc682

Hi every body! I'm from Vietnam and know only a little English.
I'm studing MS Access 2002 and there's a problem that I can't understand:
The option "Dynaset (Inconsistent Update)" of the Recordset Type property is
described that different to the option "Dynaset"; but I think they are same.
Please explain to me about different things of them.
Thanks a lot!
 
M

Michel Walsh

When speaking of Dynaset, we have to be careful about DAO and ADO, because
both use the same term, but with a completely different meaning.


In DAO, a Dynaset recordset is a recordset where membership is determined
when the recordset is created, but not after. It is like what ADO call a
keyset, ie, at the recordset creation, you determine which records are to be
displayed by the recordset, and next, forget about the WHERE clause, as
example.

SELECT * FROM somewhere WHERE UnitPrice <= 10


will get a record where unit price = 9.75 and will KEEP the record even if,
after an update, the unit price become = 12.45 (not satisfying the original
where condition). An ADO-dynaset, or dynamic recordset, (not a DAO-dynaset,
which is an ADO-keyset) would just do that, on the other hand: the record
would be removed from the recordset (not deleted from the database, just
from the recordset, a little bit as if the recordset was recreated). Jet
does NOT support ADO-dynaset. ADO recordsets open with that requirement are
downgraded to ADO-keyset.

An Inconsistent update, on the other hand, is about Relation Data Integrity
when the relation, while enforced, has NO CASCADE update. On the other hand,
I have no working example about it, with Jet.


Vanderghast, Access MVP
 
Top