Reverse Engineering a Microsoft Access 97 Database

PowerDesigner and MS Access 97 use .DAT files to exchange information. These files are reversed into the PDM. The access.mdb database uses or creates .DAT files to reverse Access databases.

You can define the database reverse parameters from the access.mdb database window.

  1. Double-click ACCESS.MDB in the PowerDesigner \tools directory.
  2. Select Reverse Engineer Access Database File to PowerDesigner Script.
  3. Type the Access database name in the Select Database box.
  4. Type the .DAT file to create in the PowerDesigner File.
  5. Click the Create button.
  6. Select DBMS > Reverse Engineering Databases in PowerDesigner.
  7. Select the newly generated script file to reverse.
  8. Click OK.
Parent topic: Reverse Engineering a Database into a PDM