Fog Creek Software
Discussion Board


I am utilizing an ADO connection to connect to an Access 2002 database.

For anyone out there who utilizes Access as their backend; what DLL's do I have to distribute with my program to make sure my users can connect to the local database? 

Do I have to install the full MDAC_TYPE.exe, or are there specific .dlls that I can package with my install?  What version of the MDAC program is most compatible?


ADO Help
Monday, March 22, 2004

All Windows versions since Windows 98 SE come with versions of MDAC that can be used with Access (98SE has MDAC version 2.1).  If you want to support the original Windows 98 then you should distribute the full MDAC_TYP.EXE with it.  If you do so then note that you should distribute one of the "old" versions of MDAC_TYP.EXE, that also include Jet.  The newer ones don't contain Jet.

Monday, March 22, 2004

Are you certain that the old versions of MDAC support ADO?  I didn't think they did (DAO, ODBC, but not ADO)

ADO Help
Monday, March 22, 2004

MDAC was the consolidation of their data access APIs into a single package. Yes, it has always included ADO.

Brad Wilson (
Monday, March 22, 2004

*  Recent Topics

*  Fog Creek Home