I have to write many complex queries involving MS Access tables joining SQL Server tables.
To write the queries quickly it would be helpful to be able to add SQL server tables from the show table dialog box in the query designer.
Apparently I have to link each SQL server table manually before it will show or write the query free hand using passthrough queries. Am I missing something obvious? Is there an easier way to add all sql server tables at once?
I do not like linked tables due to performance issues. All I need is the query syntax to add to the vba editor.
Thanks in advance for your help.