In the Microsoft Access tables that you have selected, the system checks the identifiers (table names, field names) to determine whether they are valid ODBC identifiers. If not, they are automatically converted to valid ODBC identifiers.
A valid ODBC identifier can contain uppercase and lowercase letters (A-Z, a-z), digits (0-9) and the underline character. All identifiers must begin with a letter.
In addition, the identifiers are adapted to whatever options are set, e.g. they might be converted to uppercase letters and shortened to the maximum length selected.
If the conversion procedure results in duplicate identifiers, these identifiers are numbered consecutively.
Example:
| Selected Options | |
| Uppercase Identifiers | Yes |
| Max Identifier Length | 18 |
| Original identifier | Converted identifier |
| 'Employee Telephone Office' | 'EMPLOYEE_TELEPHON1' |
| 'Employee Telephone Private' | 'EMPLOYEE_TELEFHON2' |
The next screen lists all the identifiers and conversions that apply to the selected Microsoft Access tables. If desired, this screen allows you to modify the converted identifiers to meet your own requirements.
The first column indicates whether the name is a table name or a field name. The second column specifies the original name. The third column (check box) indicates whether or not the identifier has been modified by ADABAS AccessPlus; the fourth column displays any newly converted names.
The table is structured so that one table name is displayed at the top and below it are the names of the fields belonging to the table.
The selection box at the top allows you to move directly to a specific table.
When you have finished editing the identifiers, you can begin migrating the Microsoft Access tables by clicking on the Upsize button.