Author Topic: Model MS Access database problem (Read 3287 times)

nestor · « **on:** April 20, 2005, 08:18:07 am »

I'm trying to import a MS Access Database using the Import DDL Schema from ODBC datasource dialog. I select the .mdb file, click Import, select all available tables and click OK. I then get a message "Unrecognized database format..."

This is a valid .mdb file readable by VB .Net 2003, MS Access. The necessary ODBC drivers seem to be installed on my PC.

Any ideas why this error is occuring?

TIA for any replies

thomaskilian · « **Reply #1 on:** April 20, 2005, 08:28:58 am »

I'd suspect a driver problem. What happens when you import the database into Excel?

nestor · « **Reply #2 on:** April 20, 2005, 08:51:27 am »

Although I haven't opened each table, the major ones are imported without a problem.

When I tried to import a single table into EA that worked with Excel, I still get the same problem.

nestor · « **Reply #3 on:** April 20, 2005, 10:01:08 am »

One thing I thought I noticed when I installed the latest EA version was an MSJET35.DLL file. Isn't the latest version 4.0?

thomaskilian · « **Reply #4 on:** April 20, 2005, 12:55:02 pm »

EA works with the old jet itself when accessing its own database. You can switch to jet 4.0 via the options. Maybe this has also impact on importing MS Access databases

nestor · « **Reply #5 on:** April 20, 2005, 01:02:19 pm »

Switching to Jet 4.0 did the trick.
Thanks

Sparx Systems Forum

News: