Updating Table Data with Queries
Many of the queries that you create with the Unique Records property set to Yes are updatable because you use Access SQL's DISTINCTROW modifier to create them. (Setting the Unique Records property to Yes causes Access to add the DISTINCTROW modifier to the query's SQL statement.) These queries create Recordset objects of the updatable Dynaset type. You cannot update a query unless you see the tentative (blank) append record (with the asterisk in the select button) at the end of the query result table. Queries that you create with the Unique Values property set to Yes create Recordset objects of the Snapshot type by substituting ANSI SQL's DISTINCT modifier. You cannot edit, add new records to, or otherwise update ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access