- From the Windows Start menu, select Settings, Control Panel, ODBC Data Sources (32-bit).
- Select the data source the click Configure.
- Click Options.
Table and Field Naming
The Table and Field Naming tells ODBC how to display the table and field names when accessing data via ODBC. The selection determines how portable your report is from one database to another. The options are:
- Custom descriptions
You use this when you design reports for a specific database. When you select this option, the descriptive name for tables and fields displays via ODBC. The custom description names on the report are from the database that is selected for the DSN used to create the report. The report is only portable to databases that use the same custom descriptions as the original database used when creating the report. (e.g. table name format = MASTER_JCM_Job) - Standard descriptions
You use this when you design reports for multiple databases that have different custom descriptions. When you select this option, the descriptive name for tables and fields displays via ODBC. The default custom descriptions display on the report design, but the users custom descriptions display when printing the report. The report is portable to all databases, regardless of the use of custom descriptions. (e.g. table name format = JCM_MASTER_Job) - Dictionary names
You use this when you modify Billing invoice reports and reports designed in Crystal Reports for Timberline Accounting CD versions prior to 8.0. Dictionary names are the internal table and field names. They are less descriptive than the standard description but they provide the same functionality. If you select this option, the report is portable to all databases. (e.g. table name format = MASTER_JCM_Record_x)
Use maximum table segment size
The Use maximum table segment size determines how many columns you can include in a table before the table is split into two tables when accessed via ODBC.
- When you clear the check box, a table that exceeds 255 columns is split into two tables. For example, the Job Cost Master.jcm file Job record is split into two tables, the JCM_Master_Job_1 and JCM_Master_Job_2.
- When you select the check box to use maximum table segment size, the table is not split. For example, the Master.jcm file Job record does not split and is one table, JCM_Master_Job.
Note: Some programs, including Microsoft Access, do not support the use of maximum table segment size. Clear the check box when you use DSNs associated with those programs.
Shorten field and table names:
Before ODBC 8.00.3, the ODBC driver shortened table names longer than 36 characters and shortened field names longer than 25 characters. Select the Shorten field and table names check box to create a DSN compatible with reports you designed for versions of the software prior to Accounting and Management 8.0 and Estimating 6.5. Clear the check box to create a DSN compatible with reports you designed for Accounting and Management 8.0 and later or Estimating 6.5 and later.
For more information, see ODBC Help topic Setting up Driver Options . You can find this topic by going to Start, Programs, Timberline Office, Accounting, ODBC Help. On the index tab, type Setting up Driver Options.