Database Changes

The tables and relationships specified in an Access Definition can be affected when the database changes. The effect of these changes on an Access Definition depends on the change and whether a changed object is referenced in the Access Definition.

Table Added

Adding tables to the database has no effect on an Access Definition or any process request.

Table Deleted

If a table referenced in an Access Definition is dropped from the database, the status for that table in the Access Definition Editor is Unknown and a warning message is displayed.

Although you can use an Access Definition with a table in Unknown status, it is prudent to verify that the Access Definition describes the desired data. If the Start Table is dropped, you must select a different Start Table.

Column Added

If a column is added to a database table, the new column is included in the Access Definition automatically.

Column Modified

Changes to column attributes (data length or data type) in a database table affect an Access Definition. You can use the Access Definition; however, if you use it in a process, a warning is displayed.

Column Deleted

If a column in a database table referenced in an Access Definition is deleted, the effects vary:

Relationship Added

New relationships are included in the Access Definition automatically and are assigned New status. By default, an Access Definition uses all new relationships, unless you specify otherwise.

Relationship Modified

Modified relationships are assigned New status in the Access Definition. An Access Definition uses all new relationships, unless you specify otherwise.

Relationship Deleted

Deleted relationships are assigned Unknown status in the Access Definition and a warning message indicates that the relationship is not found.

Note: Relationships that have Unknown status are ignored during a process.