Show TOC

Microsoft AccessLocate this document in the navigation structure

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 Start of the navigation path Database Next navigation step Edit Current DBMS End of the navigation path and expand the Profile node.

Note The DBMS definition file for Microsoft Access 2000 is deprecated.

The following sections list the extensions provided forMS Access.

Columns

The following extended attributes are available on the Access 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

In this section:
    Generating a Microsoft Access Database
    PowerDesigner and MS Access use .dat files to exchange information. You must pass via the appropriate access<version> 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 access<version> database delivered with PowerDesigner in order to convert an Access database file into the .dat file required by PowerDesigner.