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

Chapter 10. 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. 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:

    C:\Program Files\Microsoft Office\Access\Samples\Solutions.mdb

    To run a query against a set of Paradox tables in the D:\Paradox folder, you type the path only (d:\paradox where d: is the logical drive letter). If you're using the ODBC API to connect to a client/server database, you leave the Source Database text box empty.

    Figure 10.61. Setting the Source Database property for a query against an external database.

  • The value of the Source Connect Str property also depends on the type of external database being used. If your external Access database is not secure, leave the Source Connect Str text box empty; otherwise, type UID=UserID;PWD=Password to specify the user ID and password needed to open the external database. For other desktop databases, type the product name, such as Paradox 3.5 or dBASE IV. ODBC data sources require the complete ODBC connect string. Using ODBC databases is one of the subjects of Chapter 24, "Securing Multiuser Network Applications."


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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