Frontpage Top Issues

"Error 1919. Error Configuring ODBC Data Source" Error Messages When You Run Setup for Office 2003

The information in this article applies to:

• Microsoft Office FrontPage 2003
• Microsoft Office 2003, All Editions
• Microsoft Office Access 2003
• Microsoft Office Excel 2003
• Microsoft Office InfoPath 2003
• Microsoft Office OneNote 2003
• Microsoft Office PowerPoint 2003
• Microsoft Office Publisher 2003
• Microsoft Office Word 2003

Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

When you run Setup for any of the programs listed in the "Applies to" section of this article, you may receive the following error message:

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 the following error message:

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.

You may also receive any of the following error messages:

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.

CAUSE

These problems may occur if the Windows Registry is missing some registry keys.

RESOLUTION

To resolve this problem, replace the missing registry keys. To do this, use one of the following methods.

Method 1: Reset the Registry Keys by Using the Mdac.inf File

Use Mdac.inf to reset the registry keys.

Note – This program may prompt you for your Windows CD to obtain new files.

Do one of the following as appropriate for your operating system and if you have the Windows CD:

For the Retail Editions of Microsoft Windows 2000 and Microsoft Windows XP

1. Click Start, and then click Run.

2. In the Open box, type path\inf, where path is the path of your Windows folder, and then click OK.

   For example, type C:\Windows\Inf or C:\Winnt\Inf. By default, C:\Windows is the folder where Windows XP is installed. By default, C:\Winnt is the folder where Windows 2000 is installed and the folder where Windows XP is installed if you upgraded Windows 2000 to Windows XP.

3. On the Tools menu, click Folder Options.
4. On the View tab, in the Advanced Settings box, click Show hidden files and folders, and then click OK.
5. Right–click Mdac.inf, and then click Install.
6. If you are prompted for your Windows CD, insert the Windows CD in the CD–ROM drive or DVD–ROM drive.

7. Click the I386 folder on your hard disk (typically, C:\I386), 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 box (for example, type C:\Windows\I386 or C:\Winnt\I386), and then click OK.

8. Restart the computer.

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

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Step 1: Modify the Registry Keys

1. Locate the I386 folder on your hard disk, and then make a note of its path.
2. Click Start, and then click Run.
3. In the Open box, type regedit, and then click OK.

4. In Registry Editor, locate and then click the following key:

   HKEY_Local_Machine\Software\Microsoft\Windows\CurrentVersion\Setup

5. Right–click the Installation Sources entry, and then click Modify.
6. In the Value data box, change the value to the path of the I386 folder on your hard disk, and then click OK.
7. Repeat steps 5 and 6 for each of the following entries:
8. SourcePath
9. ServicePackSourcePath
10. Quit Registry Editor.

Step 2: Install Mdac.inf

1. Click Start, and then click Run.
2. In the Open box, type C:\Winnt\Inf, and then click OK.
3. On the Tools menu, click Folder Options.
4. On the View tab in the Advanced Settings box, click Show hidden files and folders, and then click OK.
5. Right–click Mdac.inf, and then click Install.
6. If you are prompted for your Windows CD, insert the Windows CD in the CD–ROM drive or DVD–ROM drive.

7. Click the I386 folder on your hard disk (typically, C:\I386), and then click OK.

   Notes

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

   • 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 box(for example, type C:\Windows\I386 or C:\Winnt\I386), and then click OK.

8. Restart your computer.

Method 2: Import the Registry Keys from Another Computer on the Network

Note When you import the registry keys 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 keys.

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Part 1: Export the Keys from the Registry on the "Source" Computer

1. On a computer that is not missing the keys (the "source" computer), click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.

3. Locate and then click the following registry key:

   HKEY_CURRENT_USER\Software\ODBC

4. On the File menu, click Export.

5. In the Save in box, specify a location to temporarily save the registration file (.reg file).

   In the File name box, type a file name, and then click Save.

6. Locate and then click the following key:

   HKEY_LOCAL_MACHINE\Software\ODBC

7. Repeat steps 4 and 5 to export this key.

Part 2: Import the Keys to the Registry of the "Destination" Computer

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

WORKAROUND

You may be able to work around this problem by clicking Retry several times when you receive these error messages. However, this work around may not work in the long term; you may have problems later if you try to run a Detect and Repair or a reinstallation of Office 2003.

MORE INFORMATION

For additional information about how to troubleshoot Error 1919 error messages in Office 2003, search the Microsoft Knowledge Base for Error 1919. To do so, visit the following Microsoft Web site:

http://support.microsoft.com/default.asp?scid=fh;EN-US;KBHOWTO