Book a Demo

Author Topic: Import DB Schema from Access 2000 ?  (Read 3212 times)

henrot

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Import DB Schema from Access 2000 ?
« on: October 26, 2003, 03:08:17 am »
Hello,

I try to import DB schema from an Access 2000 database.  The list of tables are correctly retrieved but when I select one or more tables and click OK, I get the error message "Unrecognized database format 'xxxxx.mdb'.

Importing from Access97 or SQL server or FroxPro DB works fine.

The PC hosts W2k SP4 + Access2000 + MDAC 2.7.

Any hint ?


Noel

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Import DB Schema from Access 2000 ?
« Reply #1 on: October 26, 2003, 01:21:13 pm »
Go to
Tools | Options...
and check the box "Use JET 4.0 - requires restart"

henrot

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Import DB Schema from Access 2000 ?
« Reply #2 on: October 27, 2003, 11:06:12 pm »
Thanks !

Noel