Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

Topic
Prev Next

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).

Prerequisites

  • The 'Microsoft Office 12.0 Access Database Engine OLE DB Provider' ODBC driver installed

Perform a Project Integrity Check

Step

Action

See also

1

Open the base project or template .eap file.

File Based Repositories

2

Select and run 'Configure > Model > Check Integrity > Project Integrity'.

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 MS 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.

Transfer the project data into an empty .accdb file

Step

Action

See also

1

Open Enterprise Architect.

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

2

Select the 'Configure > Model > Transfer > Project Transfer' menu option.

The 'Project Transfer' dialog displays.

3

In the 'Transfer Type' panel, select 'File 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 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