F. Scott Barker’s Microsoft Access 2002 Power Programming

Appendix C. Working with Data Access Objects

IN THIS APPENDIX

• Understanding Data Access Objects 2

• Creating a Database with DAO 8

• Increasing Speed with Transactions 23

• Using Custom Properties 24

As mentioned in Chapter 3, “Making Access Project and Data Technology Choices,” you now have the choice of three technologies for manipulating data in VBA. All have extremely powerful programming models that let you control your database. The first technology, Data Access Objects (DAO), has been used for several versions of Access and is discussed in this appendix. The current version of DAO is 3.6, the same as in Access 2000. Because Microsoft’s aim is to use ADO now instead of DAO, the company has chosen not to put the resources into revving DAO.

Understanding ...