• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Creating Multitable and Cros... > Updating Table Data with Queries

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. These queries create Recordset objects of the updatable Dynaset type. You can't update table data with 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 aren't updatable. The next few sections describe the conditions under which you can update a record of a table included in a query. The following sections also discuss how to use the Output Field Properties window to format query data display and editing.

Note

You can't set both the Unique Values and Unique Records properties to Yes—these choices are mutually exclusive. In Access 2000, the default setting of both the Unique Values and Unique Records properties is No.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint