Book a Demo

Author Topic: Access database engineering  (Read 3355 times)

Jeanluc

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Access database engineering
« on: December 01, 2005, 06:13:23 am »
Hi,

I need to use Database engineering on mdb database and I get an error response:

Unrecognized database format.

Isn't EA able to get database structure for an mdb standard database ?

J-Luc

thomaskilian

  • Guest
Re: Access database engineering
« Reply #1 on: December 01, 2005, 08:05:01 am »
Some time ago I did that, but it worked. Maybe it's a Jet 4 issue?

Graham_Moir

  • EA User
  • **
  • Posts: 749
  • Karma: +10/-15
    • View Profile
Re: Access database engineering
« Reply #2 on: December 20, 2005, 10:04:55 am »
J-Luc - did you ever get this fixed ?

TimWash

  • EA User
  • **
  • Posts: 26
  • Karma: +0/-0
  • Bad news does not get better with age!
    • View Profile
Re: Access database engineering
« Reply #3 on: December 21, 2005, 07:42:48 pm »
I would suggest moving away from MS Access and upgrading to either MSDE or SQL Server Express, both are free.  I would assume EA's support for these databases is much richer than for MS Access.

Tim
Tim Stevens
Programmer/Analyst
VB.NET, VB6, VBA, T-SQL, ActionScript, ColdFusion

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Access database engineering
« Reply #4 on: December 21, 2005, 09:08:59 pm »
Importing from an Access 2000 or higher database requires Jet 4 to be set in EA.

From the Tools menu, select Options | General and check the box labelled "Use JET 4.0...".

You will need to close and restart EA for the change to take effect.