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


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q212886
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you use a File DSN to import or link a FoxPro ODBC data source, you may receive the following error:
Reserved error (-7778); there is no message for this error.

RESOLUTION

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:

237819 "ODBC Call Failed" Error Message Exporting to FoxPro

STATUS

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

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kberrmsg kbpending KB212886
©2004 Microsoft Corporation. All rights reserved.