Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ====== ====== ===== Overview ===== MDAC (Microsoft Data Access Components) can become corrupted in some cases, this is typically seen when you are unable to open a Microsoft Access database, connect to it through ODBC, or in some cases can be the cause to why SMS or Control gets stuck on "loading reports...". These steps should only be taken once you have excluded all other potential causes from being the problem. ===== How to Repair MDAC 2.8 Under Windows XP with SP2 Installed ===== ==== ==== ==== General Information ==== Windows XP with Service Pack 2 contains MDAC version 2.81, which is currently not available for download at the Microsoft Web site as a standalone installation. If you try to install MDAC 2.8, which is the latest available standalone download of MDAC, you will receive a message that you already have a newer version of MDAC installed. Therefore, under Windows XP SP2, you must manually repair MDAC 2.81 as outlined below. ==== How to Repair MDAC 2.81 under Windows XP with SP2 ==== - In Windows Explorer, open the **c:\Windows\Inf** folder. - **Note** If you cannot see the c:\Windows\Inf folder, follow these steps: - On the desktop, double-click **My Computer**, and then on the **Tools** menu, click **Folder Options**. - Click the **View** tab. - Under **Advanced settings**, select the **Show hidden files and folders** check box. - Clear the **Hide extensions for known file types** check box. - Click **OK**. - In the **C:\Windows\Inf** folder, right-click the **Mdac.inf** file, and then click **Install**. - When you are prompted to insert the Windows XP SP2 CD, use one of the following methods: - __If you have a Windows XP SP2 CD__: ### Insert the **Windows XP Service Pack 2 CD** in the CD or DVD drive <html><div style="margin-left: 40px;">> **Note** If a "Welcome to Microsoft Windows XP" message appears, click **Exit**. </div></html> ### Click **Browse**. ### In the **File name** box, type CD or DVD drive that contains the Windows XP Service Pack 2 CD drive letter:\i386. For example, type d:\i386 if the Windows XP Service Pack 2 CD is in drive D. ### Click **Open**. - __If you do **not** have a Windows XP SP2 CD__: ### In the **File name** box, type %systemroot%\windows\servicepackfiles\i386, and then click **Open**. ### When prompted for **adcjavas.inc**, point to **C:\Windows\servicepackfiles\i386** <html><div style="margin-left: 40px;">> **Note:** If you cannot find this folder put the Windows CD into your CD drive and browse for that file. </div></html> ### When prompted for the file **handler.reg**, either point to **C:\Program Files\Common Files\System\msadc**, or put the Windows XP CD in your CD-ROM drive. ### When prompted for **MDACRdMe.htm**, point to **C:\Program Files\Common Files\System\Ado**. If this file is not present rename the file MDACReadme.htm to MDACRdMe.htm. ### When prompted for **oledbjvs.inc**, point to **C:\Program Files\Common Files\System\Ole DB**. ### When prompted for **mssoap1.dll**, point to **C:\Program Files\Common Files\MSSoap\Binaries**. ### When prompted for **mssoapr.dll**, point to **C:\Program Files\Common Files\MSSoap\Binaries** (or below its subfolders). - You may also be prompted for the original Windows XP CD that was used to install the operating system. - Insert the Windows XP Service Pack 2 CD in the CD or DVD drive. <html><div style="margin-left: 40px;"> **Note** If a "Welcome to Microsoft Windows XP" message appears, click **Exit**. </div></html> - Click **Browse**. - In the **File name** box, type CD or DVD drive that contains the Windows XP Service Pack 2 CD drive letter:\i386. For example, type d:\i386 if the Windows XP Service Pack 2 CD is in drive D. - Click **Open**. **Note:** In the case you cannot find those files in the given folders search the whole hard disk for them. ==== Further Optional Steps ==== Download and install [[http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156| MS Jet 4.0 Service Pack 8]]