Microsoft KB Archive/212886

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

Article ID: 212886

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

Additional query words: pra

Keywords: kberrmsg kbbug kbpending KB212886

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.