Create a Project in an Access 2007 Database

In setting up a project in an Access 2007 repository, you could be working in one of two situations:

You are able to work in Access 2007 itself, in which case you can convert your .eap project directly to an Access 2007 .accdb database file, which you can connect to and open in Enterprise Architect
You have access to an empty Access 2007.accdb file, and need to transfer a .eap project into that .accdb file
 

In either case, before you convert or transfer the project data, you could perform a project integrity check on the .eap file you are using as a base (optional, but recommended).
 

Perform a Project Integrity Check

Step

Action

See also

1

Open the base project or template .eap file.

 

 

2

Select and run Tools | Data Management | Project Integrity Check.

This ensures your project data is 'clean' before uploading.

 

Project Integrity Check

Convert a .eap file in Access 2007

Step

Action

See also

1

Open Access 2007 and open the source .EAP file within this product.

Allow Access to convert the .eap file to a .accdb file. This forms the Access 2007 repository.

 

 

2

Open Enterprise Architect and open the .accdb file containing the project, browsing for it using the Open project dialog.

 

Open a Project

Transfer the project data into an empty .accdb file

Step

Action

See also

1

Open Enterprise Architect.

(If the Open Project screen displays, click on the Cancel button to open with no project loaded.)

 

 

2

Select the Tools | Data Management | Project Transfer menu option.

The Project Transfer dialog displays.

 

 

3

In the Transfer Type panel, select .EAP to DBMS.

 

 

4

In the Source Project field, type the name of the .EAP file to copy to the repository.

If the .EAP file has Replication enabled, this must be removed before performing the transfer.

 

 

Remove Replication

5

At the right of the Target Project field, click on the ( ... ) (Browse) button.

The Datalink Properties dialog displays.

 

 

6

Select Microsoft Office 12.0 Access Database Engine OLE DB Provider from the list.

Click on the Next button.

 

 

7

On the Data Source Details page of the Datalink Properties dialog, type in the full path to the Access 2007 .accdb file.

Click on the OK button to return to the Project Transfer dialog.

 

 

8

If required, select the Logfile checkbox and type a path and filename for the data transfer log file.

 

 

9

Click on the Transfer button to begin the data transfer process.

When the process is complete, you have created your project in an Access 2007 database and can now open it directly from Enterprise Architect, browsing for the .accdb file location in the Open Project dialog.

 

 

Open a Project

Notes

This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions
If you do not have Access 2007, you can download the Access Database Engine from the Microsoft downloads site
Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic

Learn more