Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: pscott on May 12, 2009, 08:16:41 pm

Title: Reverse Engineering Access 2003 database
Post by: pscott on May 12, 2009, 08:16:41 pm

Hi,

I'm having consistent problem RE any Access 2003 database.  My ODBC drivers are up to date (using Win XP SP3), and have the latest MS service packs.

When clicking import button on the EA Import DB Schema from ODBC source, I get a listing of all the tables in the database.  No matter whether I select one or all the tables, I get a message saying 'Unrecognized database format '...'

Any suggestions on how to resolve this?

PEte

Title: Re: Reverse Engineering Access 2003 database
Post by: hd on May 13, 2009, 07:56:07 am

Set EA to use JET 4.

Tools | Options | Use JET 4.0 - requires restart

Title: Re: Reverse Engineering Access 2003 database
Post by: pscott on May 13, 2009, 10:50:24 am

Works great.  Thanks so much.  This was driving me up the wall

Title: Re: Reverse Engineering Access 2003 database
Post by: Paolo F Cantoni on May 13, 2009, 03:22:10 pm

Quote

Set EA to use JET 4.

Tools | Options | Use JET 4.0 - requires restart

Isn't it about time this was the default?

EAUI,
Paolo

Title: Re: Reverse Engineering Access 2003 database
Post by: «Midnight» on May 13, 2009, 09:39:50 pm

I asked about this a version ago, since the 2003 format will its core support period this year and the 97 format is no longer supported at all. I also suggested that the EABase project in Jet 4 format be the default distribution, or at least included in the core EA product.

The response was that this was certainly a good idea, and that they might (not would) consider it for future (unspecified) releases.

Title: Re: Reverse Engineering Access 2003 database
Post by: Paolo F Cantoni on May 14, 2009, 04:19:43 pm

Quote

I asked about this a version ago, since the 2003 format will its core support period this year and the 97 format is no longer supported at all. I also suggested that the EABase project in Jet 4 format be the default distribution, or at least included in the core EA product.

The response was that this was certainly a good idea, and that they might (not would) consider it for future (unspecified) releases.

(in Sybil Fawlty voice) I knowwww, I knowwww!  

My question was rhetorical..   :(

Paolo