Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.


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.

↑ Back to the top


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

↑ Back to the top


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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB212886, kbpending, kberrmsg, kbbug

↑ Back to the top

Article Info
Article ID : 212886
Revision : 3
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 328