You can reverse engineer an existing Microsoft Access database. This means that you can
extract the database tables, attributes, relationships, indexes and other objects from Microsoft Access
database file to your diagram.
To reverse engineer Microsoft Access database:
1. Select File | Reverse Engineer | Microsoft Access database.
2. If the currently opened diagram already contains some objects, a warning dialog box will
It requests you to create a new diagram to place the reversed objects into or use the currently
Click Yes to create a new diagram, No to use the currently opened diagram. Cancel to cancel reverse
Select Do not show this dialog again to disable future notifications.
3. The Access Reverse Engineering tool will be shown. First, type in the full path
to Access database in the Access File tab.
4. You can set the reverse engineering options in the Options tab.
Reverse engineer only tables ignoring views.
Tables and Views
Reverse engineer both tables and views.
Garbage symbols remove/replace
Defines the symbols that will be replaced in the names of the objects.
Defines the garbage replacement symbol.
This option enables extracting foreign keys from the database and creating appropriate
references in your diagram.
Automatically rebuild references when no reference is reversed
If there are no physical references extracted, it is possible to build them from logical
structure of the database.
Enabling this feature leads to automatic reconstruction of references. Such reconstruction
works by the following scheme: each column of the table is being compared with all primary keys of other
tables, and if the column name and data type match one of the primary keys, a reference between the
source column and the key column will be created.
This option is available for modification only if Build references is checked.
Tables in a Diagram row
This option defines how reversed tables will be disposed in the diagram.
Reversed tables will be placed in the diagram in rows with equal distance, this option determines how
many tables maximum there will be in one row.
5. In the Selection tab of the Access Reverse Engineering tool you can
choose the tables you want to reverse engineer.
Click on the checkbox near the table to enable its reverse engineering.
Pay attention to the Select All and Deselect All buttons on the tab, they allow you to
select/deselect all tables in the list.
6. Click OK to start the database reverse engineering process. The
Output -> Reverse docking window will display the state of the process.
7. The reversed database objects will be placed on your diagram.