Assign Table Names

Use this form to assign associate SQL Server table names with corresponding Access ones. This capability is included to apply IT department naming standards to SQL Server tables.

 

 

Access Table Name: The name of the MS-Access table.

 

SQL Server Table Name: Scriptoria generates default SQL Server table names that are identical to the corresponding Access ones. Note that SQL Server table names can be up to 128 characters in length, whereas MS-Access names have a maximum length of 64.

 

 You can enter any valid SQL Server table name. The SQL Server table names are substituted for the corresponding MS-Access table names in all table definitions and queries.