Lesson Summary


To	Do This
Set up your environment	Use the Pervasive.SQL Control Center to define data sources Define .ddf files, if necessary
Create a linked table or Create an imported table	Use the New button on the Tables tab Link or import an ODBC database Use the Machine Data Source tab to select a data source
Execute a SQL pass-through query	Use the New button on the Queries tab Choose Query > SQL-Specific > SQL Pass-Through from the Access main menu Set the ODBC Connect Str field in the query properties sheet (DSN = DSN Name) If your query will not return any data, set "Returns Records" to "No" in the query properties sheet.