SourceConnectStr, SourceDatabase Properties

Applies To

Query.

Description

You can use these properties to access external data when you can’t link the external tables to your database.

SourceConnectStr — You can use this property to specify the name of the application used to create an external database.
SourceDatabase — You can use this property to specify the external database in which the input tables or queries for a query reside.

Note The SourceConnectStr and SourceDatabase properties apply to all queries except data-definition, pass-through, and union queries.

Setting

You use a string expression to set the value of the SourceConnectStr and SourceDatabase properties.

You can set these properties in the query property sheet or in SQL view of the Query window. In the SQL statement, the properties correspond to the IN clause.

Note If you are accessing multiple database sources, use the Source property

Remarks

You must use the SourceConnectStr and SourceDatabase properties to access tables from external databases created in applications that don’t use linked tables.

The following are examples of these property settings if an application that doesn’t use linked tables accesses the data from databases created by Microsoft Access and other database products:

For a Microsoft Access database, the SourceDatabase property setting is the path and database name (for example, C:\Accounts\Customers). Microsoft Access adds the filename extension automatically. The SourceConnectStr property doesn’t have a value for a Microsoft Access database.
For a database created by a product such as Paradox, the SourceDatabase property setting is the path (for example, C:\Paradoxdata). The SourceConnectStr property setting is the specifier for the database type (for example, Paradox 3.5;). For a list of specifiers, see the Connect property.

The following example uses dBASE IV tables in the C:\Dbdata directory as the source of data for the query.

    SELECT DISTINCTROW Customers.[Company Name], Orders.[Order ID], _
        Orders.[Order Date] FROM Customers INNER JOIN Orders ON _
        Customers.[Customer ID] = Orders.[Customer ID] _
        IN 'C:\Dbdata'[dBASE IV;];

For an Open Database Connectivity (ODBC) database, the SourceConnectStr property setting is the name of the source database and any additional information required by the product, such as a logon identification (ID) and password. For example, for a Microsoft SQL Server database, the setting might be:
```
    ODBC;DSN=salessrv;UID=jace;PWD=password;DATABASE=sales;
```

The SourceDatabase property doesn’t have a value for an ODBC database.

SourceConnectStr, SourceDatabase Properties

Applies To

Description

Setting

Remarks

See Also