Microsoft Access

To create a PDM with support for features specific to the MS Access DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Database > Edit Current DBMS and expand the Profile node.

Note:

Support for Microsoft Access 95 & 97 is deprecated.

The following sections list the extensions provided forMS Access.

Columns

The following extended attributes are available on the Access 2000 tab:

Name

Description

Allow Zero Length

Specifies whether a zero-length string ("") is a valid entry in a table column.

Applies only to Text, Memo, and Hyperlink table fields.

Scripting name: ExtAllowZeroLength