![]() ![]() References allow you to select another application's objects making them available in your code by setting a reference to that application's object library. To use ADO you will need to manually add a reference to enable it, you may also need to install MDAC if not already installed. It is also possible to mix both DAO and ADO libraries in same application. Many older/existing databases may still be using ADO and so it is still fully supported. If your application needs to access multiple data sources such as Word documents, email messages or non conventional ISAM or ODBC databases then ADO may be a good choice.ĪDO does have many useful features which you can read about here, but these come at a cost of reduced performance. ActiveX Data Objects (ADO)ĪDO "Active X Data Objects" is an industry friendly connection to almost all types of database. In all recent versions of Access, the default data access library is named Microsoft Office 1x.0 Database Engine Object LibraryĭAO is the native data access method for the Jet (Microsoft Access) data tables and also works for SQL Server.ĪctiveX Data Objects (ADO) a part of Microsoft Data Access Components (MDAC) was originally intended as a replacement for DAO, but it never fully met this goal and so in 2007 Microsoft reversed its roadmap and made DAO the preferred and recommended data access library for Access. TLDR: For most purposes you should stick with the default DAO. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |