Client-Server Global Options

When the Queries have been converted to SQL Server. Scriptoria finds SQL Server views and/or procedures/functions for the current database that match MS-Access queries, the Client-Server page is shown on the Generate Access/SQL Server Application form.

The following disposition options specify which SQL Server objects will be used with the new MS-Access/SQL Server application. The default settings preserve the functionality of the original MS-Access front-end.

Global Default Settings  

By default, MS-Access queries are based on ODBC linked tables that inherit all properties of the original tables. Queries that were updatable in the original application are also updatable with some exceptions (ODBC linked tables must have a primary key to be updatable).

Selection Pass-through Query Options

Do not create pass-through queries

This option instructs Scriptoria not to create pass-through queries.

Create new pass-through queries (global default for selection queries)

This option instructs Scriptoria to create an additional pass-through queries when corresponding SQL Server views, procedures/functions are found in the current SQL Server database The original MS-Access query, now linked to corresponding SQL Server tables, remains the default query used by the application. You can set other options for individual queries using the Assign Individual QueryDefs facility..

Replace original (ODBC linked) with pass-through queries (global default for action queries)

Use this option to create new pass-through queries and to replace the original Access queries with the new pass-through ones.

Rename original before replacing with pass-through

This option creates new pass-through queries and replaces the original after it is renamed with a suffix of (LQ).

Action Pass-through Query Options

The same options available for selection queries also apply to action queries. Action queries also include the following option:

Delete all MakeTable and Append QueryDefs

It is often desirable to create SQL Server scripts that call procedures generated for MakeTable and Delete queries. To prevent Access users from inadvertent updates, set this option to "Yes" so that MakeTable and Delete queries are omitted from the converted application.

Additional Options

Substitute pass-through queries for all report RecordSources and report controls with RowSource properties

When set to "Yes," Scriptoria substitutes functionally equivalent pass-through queries (when available)  for all report RecordSource and control RowSource properties.

Assign Options to Individual Queries