I have a MySQL stored procedure that creates two temporary derived tables then selects from them with a join. I need to get the records from the select into MS Access and I haen't been able to get it to work. I call the stored procedure and it executes correctly. I just don't seem to be able to get the record set from a temp table with a pass-thru or "DoCmd.TransferDatabase acLink"
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…