Assign Schema Names to External Tables

This form displays all Append and MakeTable queries that specify external database tables. It is displayed by clicking the button or when the query processor encounters an external Append or MakeTable without an Schema specification.

 

QueryDef:

The Access query Name.

 

Type:

Append or MakeTable.

 

Schema:

Select the Schema corresponding to the one created for the associated Database File Location. All other query entries with the same Database File Location are set to the selected Schema.

 

Target Table:

The name of the table that receives resultant data.

 

Database File Location:

The location of the external Access database file used by the query.