Use the following page to set query options.
Retain MS-Access Front-End:
Check this box If you plan to retain the MS-Access front-end.
Use Module:
In order to replicate the behavior of Access parameter queries that operate with SQL Server Views, Scriptoria needs to create VBA (Visual/Access Basic) functions. Scriptoria creates new Access QueryDefs that pass parameter values to the VBA functions.
An Access module must be specified to contain these functions. Although any module will work, creating a new module for the parameter query interface functions is recommended.
Views:
SQL Server Views are automatically selected when the Retain MS-Access Front-End box is checked. The views retrieve parameter values from associated tables (created during the query conversion phase). The tables are updated with the current parameter values by the VBA user-defined functions.
Procedures / Functions:
If you plan to replace the MS-Access front-end, you can choose to generate SQL Server procedures and functions from MS-Access queries that return results.
Since ORDER BY clauses are not permitted in Functions, Scriptoria creates Procedures when queries contain ORDER BY clauses.
SQL Server procedures are generated for all MS-Access Action (Make Table, Update, Append, and Delete) and Variable Column Crosstab queries.
Scriptoria creates SQL Server procedures that us temporary tables to implement variable column Crosstab queries using the maximum number of columns allowed by either Access or SQL Server; 250 and 1000 respectively. The default is 250. Any value greater than 1 and less than or equal to 1023. If more than 250 columns are specified the procedure cannot be viewed using the Scriptoria Object Viewer since it exceeds the maximum MS-Access field limit. The pass-through query that implements the variable column Crosstab will operate as long as there are less than 250 fixed and variable columns.
Note that the first row of the last (max) column contains the select statement provides the final summary required for implementation of the variable Crosstab query. When using MS-Access as the front-end, Scriptoria automatically creates a pass-through query that fully implements the variable Crosstab query.