Working with 2 databases

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

I would like to know if you can automate an existing database (db1). In db1
have a command button that when you click on the command button will run a
query in db2 . Once the query/make table is done export table to db 1. If
this can
be done, can it be done with macros? If so can you give me a start? Thank
you
 
I would create table links in db1 (linked to the tables in db2), and run the
make table query in db1
 
I'm with Joan ... link to the tables in db2 from db1, and run your query in
db1.

By the way, you've described "how" you are trying to do something (with a
"make-table query"), but not "why" -- what will having a made table allow
you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top