Calling Query from Another DB

  • Thread starter Thread starter Sash
  • Start date Start date
S

Sash

Is it possible to call a query from another DB and have that query create a
table in my current database?
 
Hello Sash.

Sash said:
Is it possible to call a query from another DB and have that query
create a table in my current database?
Click to expand...

Yes. A make table query can create a table in a different database.
Create a make table query manually and check the sql for details.
Alternatively create a make table query that creates a table in the
local database and add tables from the other database. In the query
designer, use the properties window to change the source property
of a table icon of an individual table or change the source database
property of the query.
 

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

Record insert/delete anomaly 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Allforms Collection in another db (A2007) 4
Access how to open existing database from another database using Access - VBA 0
MS Access Table missing 3
Option to Support multiple companies 6
Access Query criteria based on other field of the same query 0
delete record from external database 6

Back
Top