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

13. Data Access Pages > 13.4. Create a DAP that Allows You to Update Data

13.4. Create a DAP that Allows You to Update Data

Problem

Most of the time, the pages you create are updateable; that is, the user can change the underlying data. Occasionally, though, the data can’t be changed, and it isn’t clear to you why not.

Solution

DAPs in Access 2000 were almost never updateable. Since Access 2002, however, most of the limitations have gone away, and you can nearly always edit the underlying data. If each group on your page is based on a single table or table query, the data is always updateable. If you base a group on a multitable, one-to-many query, the table on the “many” side of the join (or “most-many,” if there are several tables) is editable only if the key field of that table is placed on the page and the UniqueTable property for the group is set to that table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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