• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Creating Multitable and Cros... > Creating Queries from Tables in Othe...

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. The database that you open after you launch Access is called 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 Jet databases, the name of the database file. To run a query against tables contained in the Oakmont.mdb sample database from the accompanying CD-ROM, replace (current) in the Source Database text box with the following, as shown in Figure 11.76:

    Figure 11.76. Specify the full path to the external database as the value of the Source Database property.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint