Please help with cannot find linked table problem

[robmoors]

I have two tables linked via a ODBC connection. Both tables come out of the same Visual Foxpro DB. I create a new query in Access and try and link the two tables mentioned here, and I get a cannot find either table error. However, when I connect to my Access tables with one or the other table mentioned above, I have no problems. Could you please help and tell me why I am getting the error.

 

[grogery]

1. Make sure that the fields you are joining your tables on are of the same data type.

2. Have you tried using a Passthrough query? This is probably much faster than joining the Access tables.