Unable to join linked tables

  • Thread starter Thread starter Andy Levy
  • Start date Start date
A

Andy Levy

Hi

I have two tables in mySQL and i am using access as a frontend. An odbc
erroris produced when i try to Join the two tables. Has anyone got any idea
how i can Join the tables successfully. Unfortunately i cant make the query
a passthrough query as one of the fields has its values generated as the
result of a function.

Thanks

AL

also posted in formscoding - but no reply
 
If the Linking Fields are of the (MySQL) Field Type that
Access doesn't recognized, you cannnot use them for the
Link. A short while ago, I think someone posted a similar
question with Field Type Int(9) and the final solution was
to use Pass-Through Query (which you mentioned you
couldn't use).

HTH
Van T. Dinh
MVP (Access)
 
Back
Top