Article ID: 237819 - View products that this article applies to.
This article was previously published under Q237819
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2002 version of this article, see 287674
When you try to export a table by using the Microsoft Visual FoxPro ODBC driver, you may receive the following error message:
NOTE: You may also receive the following error message
ODBC Call failed
[Microsoft][ODBC Visual FoxPro Driver (#712)
One method for resolving error #200 is to download and install the latest Microsoft Data Access Components (MDAC) from the following Microsoft Web site:
ODBC Call failed
[Microsoft][ODBC Visual FoxPro Driver (#200)
You may receive the #712 error message when any of the following conditions is true:
You can work around the limitations of the Visual FoxPro ODBC driver by limiting table names and field names to eight characters and by ensuring that field names do not have spaces. Because this correction may be inconvenient because of dependencies within your database, it may be more appropriate to make the changes to a copy of the table, and then to export the result.
Although this workaround has been tested successfully on Windows NT Server and Workstation (SP5), on Windows 95 or 98, you may receive the following error message:
If you receive this error message, use Notepad to create a zero byte file. Save it as <prefix>.dbf, where prefix is the name of the table to be exported. The path name will be the location pointed to by the DSN.
The Microsoft Jet database engine could not find the object ''. Make sure that the object exists and that you spell its name and path name correctly.
Steps to Reproduce Behavior
For more information about setting up ODBC data sources, click Microsoft Access Help on the Help menu, type set up ODBC in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.