Prev Next

Create a Project in a MS Access 2007 Database

Setting up a project in an Microsoft Access 2007 repository typically involves the conversion of an existing .EAP or .EAPX file, which can be achieve in two different ways:

  • You have a working copy of MS Access 2007 itself, in which case you can convert your existing .EAP/.EAPX project directly to an MS Access 2007 (.ACCDB)
  • or, the existing repository can be Transferred into an empty MS Access 2007 base database

In either case, before you convert or transfer your existing project, you should perform a project integrity check on the source model to ensure that is 'clean' and free from data related errors.

Prerequisites

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

1. Perform a Project Integrity Check

While this step is optional, Sparx Systems do recommend that it is performed.

Step

Action

See also

1.1

Using Enterprise Architect open the source Project .EAP/.EAPX file.

File Based Projects

1.2

Select 'Configure > Model > Integrity > Project Integrity' in the ribbon.

Check Project Data Integrity

1.3

Ensure that the Action is set to 'Report Only' and that all items in 'Checks to Run' are enabled, then click

the Go button.

1.4

If Enterprise Architect detects that the existing model contains integrity issues then these will be listed, these should be corrected before continuing with the next step.

2a. Convert source project with MS Access 2007

Step

Action

See also

2a.1

Open MS Access 2007 and load the source .EAP/.EAPX file within this product.

Allow Access to convert the source project a .ACCDB file. Once this process is complete your Project is now a MS Access 2007 repository.

2b. Transfer source project to an empty .ACCDB file

Step

Action

See also

2b.1

Open Enterprise Architect.

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

2b.2

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

The 'Project Transfer' dialog displays.

2b.3

In the 'Transfer Type' panel, select 'File to DBMS'.

2b.4

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

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

Remove Replication

2b.5

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

The 'Datalink Properties' dialog displays.

2b.6

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

Click on the Next button.

2b.7

Obtain an empty MS Access 2007 base project from the Sparx Systems DBMS Based Repositories web page, rename the file name to suit the intended purpose.

2b.8

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.

2b.9

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

2b.10

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.

Managing Connections to Projects

Notes

  • Connecting to DBMS based Repositories is available in the Corporate, Unified 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