Query using VBA with local and remote tables



I'm trying to automate some of our processes and was able to make a
query "maintenance free" using a make-table query instead of modifying
a different query's criteria everytime. The problem is, while trying
to write the recordset in VBA, I realized the connection string is for
the remote database so the local table I made won't be accessible. Is
there any way to access both the local and remote table? Thanks


The smaller local table is just a list of accounts, the larger table
is our account ledger with all the transactions in it. I'm using the
inner join to filter totals for each account in the smaller table. I
think I managed to work around my problem by using
currentproject.connection instead of the connection string for the
oracle server since the tables are already linked using a file DSN in


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