Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 244904 - Last Review: June 24, 2004 - Revision: 2.0
ACC2000: ODBC Call Failed (#200) Error Running a Union Query on Linked Visual FoxPro Tables
This article was previously published under Q244904
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When you run a union query with two linked Microsoft Visual FoxPro tables, you may receive the following error message:
ODBC call failed [Microsoft] [ODBC Visual F(#200)]
Instead of using linked tables, create a SQL pass-through query that uses the Microsoft Visual FoxPro ODBC driver to perform the union query. To do so, follow these steps:
-
Create a data source that uses the Visual FoxPro ODBC driver:
-
Start the ODBC Data Source Administrator.
-
Click Add to add a data source.
-
In the list of drivers, click Microsoft Visual FoxPro Driver, and then click Finish.
-
In the ODBC Visual FoxPro Setup dialog box, type a data source name and a description.
-
Click Free Table directory, and then type or browse to the directory of free tables to which the data source connects.
-
Click OK to close the ODBC Visual FoxPro Setup window.
-
Click OK again to quit the ODBC Data Source Administrator.
-
Under Objects, click Query, and then click New.
-
In the New Query window, click Design View, and then click OK.
-
Microsoft Access displays the Show Table dialog box. Without adding tables or queries, click Close.
-
On the Query menu, point to SQL Specific, and then click Pass-Through. Microsoft Access displays the SQL Pass-Through Query window.
-
Type the code for the union query in the SQL Pass-Through Query window. The following is an example. In the example, "LinkedVFoxProTable1" and "LinkedVFoxProTable2" are the names of the two tables.
SELECT * FROM LinkedVFoxProTable1
UNION
SELECT * FROM LinkedVFoxProTable2
-
Run the query. Note that the query runs without errors and returns the recordset.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior
- In an open Access 2000 database, link two Visual FoxPro files.
- Create the following union query:
SELECT * FROM LinkedVFoxProTable1
UNION
SELECT * FROM LinkedVFoxProTable2
- Run the query. Note that you receive the following error message:
ODBC call failed [Microsoft] [ODBC Visual F(#200)]
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kberrmsg kbbug kbpending KB244904 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate