If I create an ODBC link to all the tables on our cloud based server, will this try to pull all the data down
for all the tables or simply create the link to those tables?
I want to write SQL and will use Select top 1000 Field1, Field2, Field3 from SomeTable and will
never double click a table to open it. The tables are very large and I'm concerned about bringing
production to a halt if I try to pull everything down to my .accdb
So, my question is simply this.. If I create an ODBC Link, does this only create the link which would allow me
to write my queries but not pull any data down to the .accdb?
Hope the question is clear.
Thanks in advance,
..bob