Import schema for an ACCESS mdb

[mehl]

Hello --

I am newcomer to data modeling and to EA.

I can't figure out how to import my mdb schema (an ODBC connection has been set up).

Can someone point me to terms, help screen topics, or better yet, the sequence of things to do in order to import the schema and create the DDL?

I am confused that several objects on the tree branch  Logical View offer the choice of
Code Engineering | Import DDL ... .  That choice prompts me to select a diagram, which I thought I already had.

The Help topic
"Reverse Engineer ODBC data sources"
is not clear enough for this newbie.

Was it difficult for others of you to get into EA?

Thanks in advance for any help.

Larry Mehl
[email protected]

[hd]

You need to start with an open diagram, typically Logical View | Data Model | Data Model. Double click this so that a diagram is actually open in the workspace.

Right click on the diagram, select DDL Generation | Import DDL Schema from ODBC.

Click on the button next to the Database Name textbox, and select the ODBC DSN from the Machine Data Source tab. The path to the database will appear in the textbox.

Select the Import button, and a list of available tables will appear. Select tables and click OK to import them.

[mehl]

Henk --

Thank you for the explanation.  For the benefit of future users, you might write up that sequence and put in a "Getting Started" section of Help.

I remember seeing the Database Name textbox, and its associated button appeared to be disabled, as it did this time.
Clicking the button works as you describe, however.

Problem:  After selecting the tables and clicking OK to import them, I got a message
"Unrecognized database format ... .mdb"
The Cancel Import button was the only one of the two buttons in the dialog box which was enabled.
Clicking it had no effect.  I could move the dialog box away and attempt another import, but with the same result.  Other than that, the app was hung, and needed Ctrl-Alt_del to kill it.

The mdb is from ACCESS 2000.  Is an mdb (via an ODBC) not compatible with EA?

Can you help me through this problem?

Thanks in advance.

Larry Mehl
[email protected]

[hd]

Thanks for your feedback.   We are reviewing the help file for the release of version 3.60, which is currently available to registered users for beta testing.

The existing help file | Using UML | Data Modelling | Reverse Engineer ODBC data sources - contains the steps you require.

You need to enable JET 4.0 for Access database greater then Access 97. From the menu | View | Options | check the box labelled "Use JET 4.0 - requires restart".