The most reliable way to determine which version of MDAC is installed is to compare the version number of each MDAC DLL file to a list of the DLL files that are shipped with each MDAC version. The Component Checker can help you to do this. It checks the files on the computer, compares them to a list from each version of MDAC, and reports the closest match.
Click the link to download Component Checker. When you are prompted by the browser, save cc_<CPU_arc>.msi (a self-extracting executable file) to the desktop.
On the desktop, double-click cc_<CPU_arc>.msi; this installs the Component Checker files to the default location, C:\CompChecker\.
To use Component Checker to check the MDAC version, follow these steps:
From the Start menu, click Run.
In the Open text box, type c:\CompChecker\CC.exe and then click OK.
In the Component Checker - Choose Analysis Type dialog box, select Perform Analysis of your machine and automatically determine the release version, and then click OK.
The program attempts to identify the MDAC version on your computer by scanning all of the core MDAC files and registry settings. This process normally takes several minutes. When finished, you should receive the following message:
The MDAC version that is closest to the version on your computer is 'XXXX'.
A summary of the Component Checker scan appears. Note that the Dir, FileDescription, and FileSize errors can be safely ignored.
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the registry for the version information is an easy way to double-check this information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
Note that the version information stored in the registry may be incorrect for versions of MDAC prior to 2.1 when compared with the versions of the actual files. Windows 2000 installs version 2.5. Only versions of MDAC later than 2.5 may be installed on Windows 2000.
Downloads for Microsoft Data Access Components are available at the following Web site: