As a result one can work in a more efficient manner compared with accessing tables properties windows.Designing solution architecture is about making best possible choices in context of current requirements and constraints. The DB Builder automatically manages a suitable package tree structure where all the information such as tables is stored and updated accordingly. It uses features that have been available for a long time in Sparx Enterprise Architect modelling tool. Note: Sparx EA DB Builder tool provides a dedicated user interface to work on data models.Selecting a table from the screen below provides access to its columns list.Tables and views have been imported in the Data Model including column details, primary keys, foreign keys, indexes, relations, etc.Change any option if needed and click on Import.Right click data model root > Import DB schema from ODBC.Right click on the new connection > Set as Active DB Connection.Open the System data source tab and select the entry created earlier on.

Double click on the connection and select ODBC based database.

Set up a new connection to the ODBC data source that matches the MDB file (right click on Connections > Add new DB connection).

A 'DataModel' stereotyped package has been created within the selected package with a predefined tree where tables, queries and views will be stored for each database.

Select Data Model – MSAccess from the list.

Create a new data model (right click > New Data Model).

Having the ODBC user data source available, open the EA menu Tools > Database Builder in the target EA project.

Provide a title and select the MDB file defined earlier on.

Select Microsoft Access Driver (this driver should be available if Access has been installed.Open the menu Tools > ODBC Data Sources.

Open Enterprise Architect and create the target project where the reverse engineering will be run.Create a copy of your local EA project file and rename its eap extension to mdb.This article provides a procedure to achieve this using Enterprise Architect 12.1 built-in DB Builder tool. Sparx reverse engineering features on relational databases can be run on an Enterprise Architect project to extract its schema definition such as tables, columns and relations managed by Sparx modelling tool. When one works on a local Sparx EA project, the file used has an EAP extension and is effectively a Jet Engine database that can be opened with Ms Access. Data from a Sparx Enterprise Architect modelling project is stored in a database.

Sparx architect