"Error 1919. Error configuring ODBC data source" error message when you try to install Office XP or an Office XP program

Article translations Article translations
Article ID: 324520 - View products that this article applies to.
This article was previously published under Q324520
Expand all | Collapse all

On This Page

Symptoms

When you try to install Microsoft Office XP or an Office XP program, you may receive an error message that is similar to the following:
Error 1919. Error configuring ODBC data source: MS Access Database. ODBC error 6: Component not found in the registry. Verify that the file MS Access Database exists and that you can access it.
If you click Ignore, you may receive one or more error messages similar to the following:
Error 1919. Error configuring ODBC data source: Excel Files. ODBC error 0: Verify that the file Excel Files exists and that you can access it.
Error 1919. Error configuring ODBC data source: MS Access Database. ODBC error 0: Verify that the file MS Access Database exists and that you can access it.
Error 1919. Error configuring ODBC data source: Visual FoxPro Database. ODBC error 0: Verify that the file Visual FoxPro Database exists and that you can access it.
Error 1919. Error configuring ODBC data source: Visual FoxPro Tables. ODBC error 0: Verify that the file Visual FoxPro Tables exists and that you can access it.
Error 1919. Error configuring ODBC data source: dBASE Files. ODBC error 6: Verify that the file dBASE Files exists and that you can access it.
If you click Retry, the program appears to install correctly, but it may not work correctly.

Cause

This problem may occur when the following registry subkeys are missing:
HKEY_CURRENT_USER\Software\ODBC

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
These subkeys may have been removed if you removed a Corel program, including a program in the Corel WordPerfect Office family of products.

Resolution

To resolve this problem, you must replace the missing subkeys. To do this, use one of the following methods.

Method 1: Install MDAC 2.8

To install MDAC 2.8, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/data/aa937712.aspx
For more information about MDAC 2.8, including removal instructions, visit the following MSDN Web site:
http://msdn2.microsoft.com/en-us/library/ms810805.aspx
After you install MDAC 2.8, you should restart the computer and then log on with administrator privileges before you try to install Office again.

Note MDAC 2.8 is also installed when you install Microsoft Windows XP Service Pack 2 (SP2). If you use Windows XP, you may choose to install Windows XP SP2 instead of following the previous steps. To install Windows XP SP2, visit the following Microsoft Web site:
http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=en-us

Method 2: Reset the Registry Subkeys by Using Mdac.inf

When you use the Mdac.inf file to reset the registry subkeys, you may be prompted for your Microsoft Windows CD so that you can obtain new files. The following methods depend on how your operating system was installed and whether you have your installation CD. Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

For Microsoft Windows 98, Microsoft Windows Millennium Edition, or the Retail Editions of Microsoft Windows 2000 and Windows XP

  1. Click Start, click Run, type path\inf in the Open box, where path is the path of your Windows folder, and then click OK.

    For example, type C:\Windows\Inf or C:\Winnt\Inf.

    Note By default, C:\Windows is the folder where Windows 98, Windows Millennium Edition, or Windows XP is installed. By default, C:\Winnt is the folder where Windows 2000 is installed, and it is also the folder where Windows XP is installed if you upgraded Windows 2000 to Windows XP.
  2. On the Tools menu, click Folder Options, and then click the View tab.
  3. In the Advanced Settings dialog box, click Show hidden files and folders, and then click OK.
  4. Right-click Mdac.inf (for Windows 2000 or Windows XP) or Mdacinst.inf(for Windows 98 or Windows Millennium Edition), and then click Install.
  5. If you are prompted for your Windows CD, insert the Windows CD in your CD-ROM drive or in your DVD-ROM drive.
  6. Locate the I386 folder on your hard disk (typically, C:\I386), click the folder, and then click OK.

    Note If the I386 folder is a subfolder of the Windows folder, on some computers, you cannot select it. In this case, type the full path in the Copy files from text box (for example, type C:\Windows\I386 or C:\Winnt\I386), and then click OK.
  7. Restart the computer.

For Original Equipment Manufacturer (OEM) Editions of Windows 2000 or Windows XP

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows

Step 1: Modify the Registry Subkeys

  1. Locate the I386 folder on your hard disk, and then make a note of its path.
  2. Click Start, click Run, type regedit in the Open text box, and then click OK.
  3. In Registry Editor, locate and then click the following subkey:
    HKEY_Local_Machine\Software\Microsoft\Windows\CurrentVersion\Setup
  4. Right-click the Installation Sources entry, and then click Modify.
  5. In the Value data box, change the value to the path of the I386 folder on your hard disk, and then click OK.
  6. Repeat steps 4 and 5 for each of the following entries:
    • SourcePath
    • ServicePackSourcePath
  7. Quit Registry Editor.

Step 2: Install Mdac.inf

  1. Click Start, click Run, type C:\Winnt\Inf in the Open text box, and then click OK.
  2. On the Tools menu, click Folder Options, and then click the View tab.
  3. In the Advanced Settings dialog box, click Show hidden files and folders, and then click OK.
  4. Right-click Mdac.inf, and then click Install.
  5. If you are prompted for your Windows CD, insert the Windows CD in your CD-ROM drive or in your DVD-ROM drive.
  6. Locate the I386 folder on your hard disk (typically this path is C:\I386), click the folder, and then click OK.

    NOTES

    If you do not have the CD for your current Windows installation, click Browse, locate the I386 folder, and then select it.

    If the I386 folder is a subfolder of the Windows folder, on some computers, you cannot select it. In this case, type the full path in the Copy files from text box (for example, type C:\Windows\I386 or C:\Winnt\I386), and then click OK.
  7. Restart your computer.

Method 3: Import the Registry Subkeys from Another Computer on the Network

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows


Note When you import the registry subkeys from another computer, make sure that the source computer and destination computer run the same operating system. For example, if you are using this method on a computer that is running Windows XP, locate a computer that runs Windows XP that you can use to export the registry subkeys.

Part 1: Export the Subkeys from the Source Computer's Registry

  1. On a computer that is not missing the subkeys (this is about your source computer), click Start, click Run, type regedit in the Open text box, and then click OK.
  2. Locate and then click the following subkey:
    HKEY_CURRENT_USER\Software\ODBC
  3. On the File menu, click Export.
  4. In the Save in dialog box, specify a location to temporarily save the registration file (.reg file) to. In the File name box, type a file name, and then click Save.
  5. Locate and then click the following subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
  6. Repeat steps 3 and 4 to export this subkey.

Part 2: Import the Subkeys to the Destination Computer's Registry

  1. Copy the exported .reg files from the source computer to a temporary location on the computer that is missing the subkeys (the destination computer).
  2. Click Start, click Run, type regedit in the Open text box, and then click OK.
  3. On the Registry menu, click Import Registry File.
  4. Locate and then click one of the .reg files that you copied in step 1, and then click Open.
  5. Repeat steps 3 and 4 for the other .reg files.

More information

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Properties

Article ID: 324520 - Last Review: March 6, 2013 - Revision: 7.0
Applies to
  • Microsoft Access 2002 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft FrontPage 2002 Standard Edition
  • Microsoft Outlook 2002 Standard Edition
  • Microsoft PowerPoint 2002 Standard Edition
  • Microsoft Publisher 2002 Standard Edition
  • Microsoft Word 2002
  • Microsoft Office XP Professional Edition
  • Microsoft Office XP Small Business Edition
  • Microsoft Office XP Standard Edition
  • Microsoft Office XP Developer Edition
Keywords: 
kbtshoot kberrmsg kbprb KB324520

Give Feedback

 

Contact us for more help

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