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.

  1. Select Database > Generate Database to launch the standard Database Generation dialog (see Generating a Database from a PDM), set any appropriate options, and click OK.
  2. Open the appropriate accessversion database in the PowerDesigner \tools directory.
  3. Select the Generate Access database from script file radio button and enter or select a destination database file in the Select database field.
  4. Select the .dat file generated by PowerDesigner in the Script file field.
  5. Click the Create button to create the database file, and then click the Open MDB button to open the generated database.