Query using VBA with local and remote tables

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
 
A

AngeloUCF

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
 

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

Similar Threads

Help! Mental Block! 1
Creating a select query using sql in VBA 6
VBA & Linked Tables 3
Using a query form in VBA 1
Link to tables via VBA 2
Add recordset data to local linked table. 1
Error Exporting Access Query Results to Excel 1
howto Create recordset in VBA using SQL statement as string 5

Top