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

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

Using ADO to Execute Action Queries and Stored Procedures

If you prefer to use ADO instead of DAO (or if you're not using a Jet database so that DAO isn't available), you'll need to adjust your VBA code to make use of ADO objects. The examples in this section use ADO's Command object which, along with the Connection and the Recordset objects, is one of the three fundamental objects in the ADO model. You generally use the Command object when your code will execute an action query—more broadly, a stored procedure.

NOTE

ADO tends to follow SQL Server terminology in this area, and SQL Server uses the term stored procedure instead of action query. The two terms are not synonymous, however: SQL that Access would term action queries constitute part but not all of stored procedures.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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