How To Control Which MDAC Version the Package and Deployment Wizard (PDW) Distributes

Article translations Article translations
Article ID: 217754 - View products that this article applies to.
This article was previously published under Q217754
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


The purpose of this article is to help you understand how the Visual Basic 6.0 Package and Deployment Wizard (PDW) distributes the Microsoft Data Access Components (MDAC) in order to allow you to control which version of MDAC is distributed with your application.


When you reference ActiveX Data Objects (ADO) in your Visual Basic 6.0 project, and use the Package and Deployment Wizard to build the install, the wizard uses the MDAC_Typ.exe file in the ...\Wizards\PDWizard\Redist directory.

If you install Visual Basic 6.0 and then later install MDAC 2.1 or later through the SQL Server 7.0 Client utilities or some other method and make no other changes, then MDAC 2.0 is distributed with your application. In order to distribute MDAC 2.1 or later with your application, you need to replace the version of MDAC_Typ.exe that resides in the ...\Wizards\PDWizard\Redist directory with the newer version of that file.

You may obtain the latest MDAC release and see a list of available MDAC releases available for distribution from


Article ID: 217754 - Last Review: February 21, 2014 - Revision: 4.4
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
kbnosurvey kbarchive kbdatabase kbdeployment kbhowto KB217754

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from