I have created a link to a MySQL table in an Access DB.
I can run regular queries on the link with no problem.
If I try to run a passthrough query on it, however, Access asks me to select the data source (even though the connection parameters are stored in the link).
I'm not sure why and I don't think this is expected behavior for Access.
Can someone help me troubleshoot?