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

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

Generating a Microsoft Access Database
PowerDesigner and MS Access use .dat files to exchange information. You must pass via the appropriate accessversion database delivered with PowerDesigner in order to convert the .dat files generated into Access database files.
Reverse Engineering a Microsoft Access Database
PowerDesigner and MS Access use .dat files to exchange information. You must pass via the appropriate accessversion database delivered with PowerDesigner in order to convert an Access database file into the .dat file required by PowerDesigner.

Parent topic: Other Databases