Connecting to an Access database that has a mix of Access and Linked ODBC tables

I have an Access database (.mdb) that has some tables which are native and some which are linked to an ODBC database (actually a remote SQLServer database)

I'm now attempting to convert some of our VBA applications into, and am having problems when accessing queries that contain a mix of the above tables.

I'm able to construct working connections to native tables and to ODBC tables, but can't work out how to access a query that uses both.

Has anyone got any experience of this? Is it possible?

0 answers