Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Updating Data

Updating data has already been discussed and illustrated in the “Inserting Data” section earlier in this chapter; we were just updating new data instead of existing data. Updating records, via code, in a table (or Recordset) can be accomplished in several ways, some of which are

  • The Execute method as it applies to DAO’s Database and QueryDef objects, as well as ADO’s Connection and Command objects

  • Modification of Field values of a record in an updatable DAO or ADO Recordset object


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint