Microsoft KB Archive/244904

= ACC2000: ODBC Call Failed (#200) Error Running a Union Query on Linked Visual FoxPro Tables =

Article ID: 244904

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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).



SYMPTOMS
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)]



RESOLUTION
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.</li> Click OK to close the ODBC Visual FoxPro Setup window.</li> Click OK again to quit the ODBC Data Source Administrator.</li></ol> </li> Under Objects, click Query, and then click New.</li> In the New Query window, click Design View, and then click OK.</li> Microsoft Access displays the Show Table dialog box. Without adding tables or queries, click Close.</li> On the Query menu, point to SQL Specific, and then click Pass-Through. Microsoft Access displays the SQL Pass-Through Query window.</li>  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 </li> Run the query. Note that the query runs without errors and returns the recordset.</li></ol>

<div class="status_section">

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

<div class="moreinformation_section">

Steps to Reproduce Behavior
<ol> In an open Access 2000 database, link two Visual FoxPro files.</li>  Create the following union query: SELECT * FROM LinkedVFoxProTable1 UNION SELECT * FROM LinkedVFoxProTable2 </li> Run the query. Note that you receive the following error message:

ODBC call failed [Microsoft] [ODBC Visual F(#200)]

</li></ol>

Additional query words: pra attached err

Keywords: kberrmsg kbbug kbpending KB244904

-

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

© Microsoft Corporation. All rights reserved.