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 VB.net, 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?