download microsoft activex data objects 2.8 library

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. I hope this helps anyone else that might have this same issue arise with them.TLDR: For most purposes you should stick with the default DAO. I decide not to go this route unless I had to because I already kill the Office applications on one machine by copying my maso15.dll file to their machine. I read some where in the MS knowledge base to do this in a test environment because it may cause some problems. I was looking in to the redistributable installer for the MDAC 2.8 release and was going to run it on all our computers 15-20. I figured this must be why it showed that the reference library was missing but when I went to the path of where it was suppose to be the file was there.

I download the file and discovered that there where different version of the maso15.dll file. In the Microsoft knowledge base you can download a program to check which version of Microsoft Data Access Components (MDAC) that is installed on a system. Since this will only be used in my group I can easily have one co-worker add the reference library on the remote computers. You might not want the user to have access to your VBA code. Of course this method will not work for everyone. In fact one user had Microsoft ActiveX Data Objects 2.5 and this worked fine.

By not checking the reference library to Microsoft ActiveX Data Objects 2.8 in my PowerPoint file (Tools>Reference) and letting the user install it you did not run in to any problems will different version of the msao15.dll file.

Download microsoft activex data objects 2.8 library