Query using VBA with local and remote tables

  • Thread starter Thread starter Muscat.Angelo
  • Start date Start date
M

Muscat.Angelo

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
access.

Angelo
 
Back
Top