MS Access 2003 – Adding Tables from Another Database into a Query

Untitled Document

The traditional way of adding a table from an external database into a query is by linking the table to your database.

There is another way, however.

In the query design grid, right click anywhere in the grey area.

Click Properties.

When the properties window pops up, type the full path of the external database in the Source Database box.

For additional information about designing Access Queries, see our course: Access Queries from A to Z.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>