Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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.
|
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.
|
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.
|
|
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.
|
|
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
