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

Chapter 8. Opening Databases > Opening a Database Using DAO

Opening a Database Using DAO

So far, this chapter has focused on opening a database using ADO. If you don't have access to ADO, or if you're opening a database that uses the Jet database engine (as a practical matter, this means Microsoft Access databases), you should consider using DAO instead.

As mentioned earlier in this chapter, DAO is optimized for Jet and you'll get better performance using DAO on Jet databases than using ADO. (Admittedly, the delta isn't large.) And DAO syntax is identical to ADO syntax in many ways, so when it comes time to shift your code from using DAO to using ADO, the change will not be as painful as it might have been to shift from, say, Lotus 1-2-3 to Excel.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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