ODBC Error - Could not execute query

[julieatnexus]

I use a Visual Fox Pro ODBC driver to link tables in an Access Project. When I do a query that uses more than one table I get the error:

Could not execute query; could not find linked table
[Microsoft][ODBC Visual Fox Pro Driver]Fil(#173)

If I take one table and do a make-table query, I can then do another query to bring in the information from the second table but again, I can not bring in another table.

I need to make queries using up to 10 linked tables. Having to use make-table queries is not only alot of extra work, but unnecessary memory consumption.

Any ideas?

 

[edge2000]

This sounds like the odbc driver, we had a similar problem with a Sage ODBC driver, only solution for us was to transfer the data into access on table by table basis and work on those unfortunatly.

Dave
dab@completebs.com

http://www.completebs.com

See website for more info but we can develop most things for most people.