O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

5.5. Summary

This chapter covered one of the most important concepts in Access programming—working with data in databases. You should now understand the basics of retrieving and modifying data from VBA code using ActiveX Data Objects (ADO) and using the ADO object model—namely the Connection, Command, and Recordset objects. You also learned how to work with recordsets that are bound to the form and maintain an open connection and those that are disconnected. When recordsets are disconnected from the data source, changes made locally are not saved to the underlying database unless you take additional steps. You also learned how to use Select, Insert, Update, and Delete statements in the SQL language to interact with the database. Finally, you learned that the ADOX object model allows you to manipulate database tables and so on.

The next chapter discusses various techniques you can use to build interactive forms. It provides you with some useful approaches for improving user interaction.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required