ACC2000: Using File DSN to Import or Link a FoxPro ODBC Data Source Causes Reserved Error -7778

When you use a File DSN to import or link a FoxPro ODBC data source, you may receive the following error:

Use a Machine DSN (that is a User or System DSN) instead of a File DSN.

NOTE: The table that you are exporting must adhere to Foxpro naming standards. For example, if you export a table that has field names which are greater than 8 characters in length, the export will fail with a different reserved error. For additional information about this issue, click the article number below to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Steps to Reproduce the Behavior

1. If you are running Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT, open Control Panel, and then double-click the ODBC Data Sources icon. If you are running Microsoft Windows 2000, click Start, point to Programs, point to Administrative Tools, and then click Data Sources (ODBC).
2. Click the File DSN tab, and then click Add.
3. Click Microsoft Visual FoxPro Driver, and then click Next.
4. Type fdsnFoxPro in the box, click Next, and then click Finish.
5. Click Free Table directory, click Browse, and select a folder that contains one or more .dbf files. If you performed a default installation of Access 2000, Customer.dbf, Employee.dbf, and Orders.dbf are located in C:\Program Files\Microsoft Office\Office\1033.
6. After you select a path, click OK, and then click OK again to close the Configure Connection dialog box. Click OK one more time to close the ODBC Administrator.
7. Open any database in Microsoft Access 2000.
8. On the File menu, point to Get External Data, and then click Import or Link Tables.
9. In the Files of type list, click ODBC Databases().
10. Click fdsnFoxPro.dsn, and then click OK.

Note that you receive the error message that is mentioned in the "Symptoms" section of this article.