querydef: how to reference external odbc tables

M

mikeg

i've been trying and finally give up....
i need to write a query in ms-access which points to data in an external odbc.

i can successfully do it on the fly in vba code, but i cant seem to figure
out how to pass along the connectionstring information when hardcoding a
querydef.

thanks folks!
mikeg
 
Top