Working with 2 databases

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
 
J

Joan Wild

I would create table links in db1 (linked to the tables in db2), and run the
make table query in db1
 
J

Jeff Boyce

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
 

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

I figured out the issue thank you. 0
Creating a Search using a combo box and then creating a report. 4
Clearing combo boxes and a text box 2
Access - Macro - table not exist 0
Open database 2
Working outlook via vba code with xlsx - error 0
Prompt For Replace in Selection And More... 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top