Summary

This chapter is about managing the operation of Jet SQL inside Access applications. The chapter begins with an introduction to the basics of Jet SQL for several common data access tasks. Next, the chapter introduces ADOX views and procedures collections. Both views and procedures contain Jet SQL statements. Two subsequent sections drill deeper on views and procedures; the first investigates row-returning queries and the second demonstrates how to create and run action queries with parameters for inserting, updating, and deleting rows through record sources such as tables and queries. The chapter concludes with a section that demonstrates selected data definition language (DDL) capabilities of Jet SQL, in particular how to create a table and modify the seed and step values for an AutoNumber field.