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

Chapter 12. Controlling a Database from ... > Using DAO to Execute Action Queries

Using DAO to Execute Action Queries

Action queries were discussed in some detail in Chapter 9, “Managing Database Objects,” but from an interactive standpoint. There, in “Creating Queries,” you saw how to use Update, Delete, and Append queries to change data, remove records, and add them to the underlying tables. The context was that of a user employing the queries directly from the database's user interface.

But just as you can combine VBA with DAO or ADO recordsets to return data via Select queries, you can cause VBA to run action queries from the Excel platform, and thereby update, delete, and append records in a database. You can do this with queries that have been saved in the database or you can submit the queries' SQL along with the commands to execute them.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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