Create a Project in a MS Access 2007 Database

1.1

Download  eabase-XXXX-accdb.zip  (where XXXX is the latest schema version number) from the Sparx Systems website, and unzip the file contained within to a temporary location.

1.2

Move file EABaseXXXX.accdb to an appropriate location on your local hard drive and at the same time rename the file to something meaningful for the current project.

2.1

The Windows Operating System includes two different versions of the ODBC administrative tool, one for 32 bit and the other for 64 bit applications. Therefore you need to open the 'Open Data Source Administrator' that corresponds to the architecture of your Enterprise Architect application. The easiest way to achieve this is to use Enterprise Architect's build-in ribbon option: 'Settings > User Tools > ODBC Data Sources'.

The ODBC Data Source Administrator window displays.

2.2

The DSN can be saved as either a User or System DSN, if you have administrator privileges on the local machine then we would suggest saving the DSN  as a System DSN, otherwise your only option is to create a User DSN.

2.3

Click on the Add button.

The 'Create New Data Source' dialog displays, enabling you to add a new DSN.

2.4

Select 'MS Access Driver (*.mdb, *.accdb)' from the list.

Note: Make sure NOT to select  'MS Access Driver (*.mdb)' without the '*.accdb'; this is the older driver and does not work with MS Access 2007 databases.

2.5

Click on the Finish button.

The  'ODBC Microsoft Access Setup' dialog is displayed.

2.6

Enter these configuration details:

• Data Source Name: (DSN), a unique name for the connection
• Description: (optional) description of the DSN

2.7

Click on the Select button to display the Select Database screen. Use this to browse for and select the database file, which was renamed in step 1.2.

2.8

Click on the OK button on the Select Database screen.

2.9

Click on the OK button on the ODBC Microsoft Access Setup screen.  This will save the ODBC DSN.

2.10

If the test succeeds, click on the OK button to complete the configuration.

If the test does not succeed, review your settings.

3.1

Open the 'Data Link Properties' dialog using one of these methods:

• Keyboard Shortcut:  Ctrl+O : Connect to Server
• Start Page | Server Connection (direct to 'Open Server Connection' dialog)
• | Open Project : Connect to Server
• Start Page : Manage Projects : Connect to Server

3.2

On the 'Provider' tab select 'Microsoft OLE DB Provider for ODBC Drivers', click on the Next >> button.

3.3

Select the ODBC DSN defined in Stage 2 in the 'Use data source name' combo; click on the Test Connection button.

3.4

Once step 3.3 is successful, click on the OK button to open the repository.

If the test does not succeed, review your settings.

4.1.1

Using Enterprise Architect, open the source project .EAP/.EAPX file.

4.1.2

Select the 'Settings > Model > Integrity > Project Integrity' ribbon option.

4.1.3

Ensure that in the 'Action' panel 'Report Only' is selected, and that all checkboxes in the 'Checks to Run' panel are selected, then click on the Go button.

4.1.4

If Enterprise Architect detects that the existing model contains integrity issues, they will be listed in the main panel at the bottom of the dialog. These issues should be resolved before continuing with the project transfer.

4.2.1

Open Enterprise Architect.

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

4.2.2

Select the 'Settings > Model > Transfer > Full Project Transfer via Connection' ribbon option.

The 'Project Transfer' dialog displays.

4.2.3

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

4.2.4

In the 'Source Project' field, click on the button and browse for and select the name of the .eap or .eapx file to copy to the repository.

4.2.5

At the right of the 'Target Project' field, click on the   button and click on the 'ODBC Connection Wizard' option.

The 'Datalink Properties' dialog displays.

4.2.6

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

Click on the Next button.

4.2.7

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

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

4.2.9

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

4.2.10

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

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