O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required