Creating Queries from Tables in Other Databases
Access's Query Properties window includes two properties that let you create a query based on tables contained in a database other than the current database. Access calls the database that you open after you launch Access the current database. Databases other than the current database commonly are called external databases. The use of these two properties is as follows:
The value of the Source Database property for desktop databases is the path to the external database and, for Access databases, the name of the database file. To run a query against tables contained in the Solutions.mdb sample database, replace (current) in the Source Database text box with the following, as shown in Figure 10.61 ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
