Importing DB Schema from Access

[DaveMere]

Hi all,

I've been trying to import a DB schema from MS Access, but with no luck so far. EA reads and displays the database tables but when I click "Import" I get the following message;
"Unrecognised database format <filepath>"

Anyone else experienced this and know what I can do about this?

Thanks

Dave

[«Midnight»]

You could be having a problem with the Jet driver version. Try opening the Tools / Options dialog. On the General page (which should be the default) check the Use JET 4.0 box. Remember that you must exit and restart EA for this to take effect. The Jet 4.0 driver usually handles earlier databases gracefully; the Jet driver from Office 97 (which is the default) does not like being presented with a later file, but there's no advance warning.

[DaveMere]

Great, that did the trick.

Thanks Midnight