Monday, January 12, 2009

How to Determine which Microsoft JET version is installed

The easiest way to determine which version of the Microsoft JET ADO access component (MDAC) installed is to check the registry under "HKEY_LOCAL_MACHINE,\Software\Microsoft\Jet\" . You should see a folder under this one that is named with version of the JET component, like 3.5 or 4.0.

It's also pretty easy to check \Windows\System32\msjet*.dll for a version, as suggested by this MS KB article : http://support.microsoft.com/kb/239114/.

More complicated is installing Microsoft's Component Checker - which I did and found to be overkill for my simple task. It lists the version with the DLL name.

To use Component Checker, select the top radio button labeled 'Perform analysis...'. Once you get the exact MDAC version select that version in the second radio button labeled ''Perform analysis against a selected version'. Apparently, 'odbcjt32.dll' is the ODBC connector in the MDAC so you can check it for a version.

It is interesting though, that this MS KB article suggests you check the \Windows\System32\msjet*.dll for a version, yet I could not find any msjet*.dll files listed in the component checker.

No comments: