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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

querydef: how to reference external odbc tables 1
querydef: using external odbc 4
How to remove external organization from Office. 0
Embedded Excel into Word with Tables 0
write querydef that points to odbc datasource 2
How to paste this down? 3
Loading external Data in Access Table - whats the most Efficient 8
ODBC Linked Tables 0

Top