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

Chapter 16. Upsizing Wizard > Converting VBA Programs

Converting VBA Programs

Access projects only support the ActiveX Data Objects (ADO) database programming interface. In Access 2000 and Access 2002 mdb databases you can use ADO and Data Access Objects (DAO). In Access releases earlier than Access 2000, only DAO was available for Visual Basic programming. In Access 2000 and Access 2002 mdb databases, both database interfaces work in parallel: DAO is used internally for all queries, forms, and reports; and ADO is generally intended for user programming.

In our Access 2000 and Access 2002 mdb applications, we were unable to use ADO alone because we almost always had to use DAO for programming complex forms and reports, for example. In our seminars we often recommend that users program with DAO to avoid having to learn two different database programming interfaces. On the other hand, the future belongs to ADO!


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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