Book a Demo

Author Topic: Database Schema Import Issue  (Read 2443 times)

sbarkeruk

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
    • View Profile
Database Schema Import Issue
« on: April 08, 2005, 07:15:29 am »
Am trying to import an MS Access Database (The NorthWind sample) via ODBC but get a 'Unrecognised Database format' error (even though it has just shown me a list of tables, etc!!

This was done as follows:

1) Create a new project and select MSAccess as the default DB.
2) Select Project | DataBase Engineering | Import DB Schema from ODBC.
3) Choose Import as New Objects.
4) Click the ellipsis button (...) next to Database Name.
5) Click Machine Data Source | MS Access Database | OK.
6) Choose NorthWind.mdb then click OK.
7) Choose Import | Select All | OK.
??? Get the error 'Unrecognised Database format <path>NorthWind.mdb' at this point (when getting the details for the selected tables).

Simon

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Database Schema Import Issue
« Reply #1 on: April 10, 2005, 03:09:10 pm »
You are probably importing an Access 2000 or higher database, which requires Jet 4.

From the Tools Menu, select Options | General and chaeck the  Use JET 4 check box. Restart EA.