Microsoft Access VBA - Using DAO, ADO and Access Database Engine Objects

- NN.0 Microsoft Access Object Library (where NN depends on the version you use - 12 If you are using Access 2007, 11 if you use Access 2003, 13 if you are using Access 2010)
- Or the Microsoft Data Access Objects, ActiveX Data Objects or Access database objects, depending on which version of Access you are using

.

Select Technology

In the beginning was Microsoft Access to and including the 97th version of the If you write VBA within the old database like this, you have no choice -. You will need to use direct access, or DAO

If you are using Access 2000, 2002/XP, or 2003, your best choice would probably be the ActiveX Data Objects, or ADO. It comes in many versions (usually 2.0 to 2.8 and 6.0) - each will do. ADO has the advantage that it is faster than DAO, and allows you to connect to other data sources (not just the database engine of Access ).

Finally, if you use Access 2007 or 2010, your best option would be to take advantage of access to database objects.

Similarities and differences

When you write code in VBA, there are more similarities than differences between the three technologies. Most importantly, all contain the term Recordset, which was opened as a table in VBA. You can go to the first, previous, next or last record in the Recordset, but it can not go outside the BOF or EOF mark (beginning of file / End of file ).

It is hoped that some light is thrown on this subject - and that Microsoft will announce another motorcycle Access database to access 2013