Special Edition Using Access 97, Second Edition

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 ...