Book a Demo
« previous next »
Pages: [1]

Author Topic: Import DDL Schema from MS Access fails  (Read 4139 times)

nifsmith

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Import DDL Schema from MS Access fails
« on: June 28, 2005, 02:16:53 pm »
This may be linked to a post below but I have tried to import a DDL Schema from an Access .mdb file using EA 767 and the import failed to complete.

I created a System Data Source linked to a .mdb file. Starting the import EA wil list the tables in the Access database but on continuing the import EA fails with the message "Unrecognised Database Format filename.mdb"

This seems to fail at a different point from the post below. Anyone else experienced the same problem or can see where I'm going wrong.

TYIA nifsmith
Logged
People should not be afraid of their Governments. Governments should be afraid of their people.

V

sargasso

  • EA Practitioner
  • ***
  • Posts: 1406
  • Karma: +1/-2
  • 10 COMFROM 30; 20 HALT; 30 ONSUB(50,90,10)
    • View Profile
Re: Import DDL Schema from MS Access fails
« Reply #1 on: June 28, 2005, 05:01:37 pm »
I've invoked another demon!  >:(

Now the same thing is happening to me.  EA crashes on a DDL import - no warning no rationale and a lousy XP error message offering to send my personal details to guess who.

Could any of the administrators lets us know if they are looking at this please?

bruce
Logged
"It is not so expressed, but what of that?
'Twere good you do so much for charity."

Oh I forgot, we aren't doing him are we.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Import DDL Schema from MS Access fails
« Reply #2 on: June 28, 2005, 06:08:30 pm »
It's a bug in the non-unicode version,  :-[ which has been fixed for the next build.
Logged

nifsmith

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: Import DDL Schema from MS Access fails
« Reply #3 on: July 02, 2005, 09:15:59 am »
I have tried to import an access .mdb on the unicode version of build 766 and all the non unicode previous versions of EA back until the last build of 4.51 and I cannot import an Access .mdb. ???

This must be something I am doing wrong as this would be a bigger problem if everyone else were encountering it.

My import always fails after I have selected the tables I want to ODBC import from.

Another thing that seems to be different is the failure to import an .mdb does not cause EA or XP to crash. The import box just hangs and on canceling it everything works no problems.

Not sure if this could be a symptom but it always gives the fully qualified pathname to the database and states its an unrecognised database format i.e 'D:\my databases\thedatasource.mdb' instead of just  thedatasource.mdb.
« Last Edit: July 02, 2005, 09:19:48 am by nismith »
Logged
People should not be afraid of their Governments. Governments should be afraid of their people.

V

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Import DDL Schema from MS Access fails
« Reply #4 on: July 03, 2005, 03:19:20 pm »
Quote
Not sure if this could be a symptom but it always gives the fully qualified pathname to the database and states its an unrecognised database format i.e 'D:\my databases\thedatasource.mdb' instead of just  thedatasource.mdb.

This error is usually caused by working with Jet 4 databases using the Jet 3 engine.
When importing from Access 2000 or greater, set "Use Jet 4" on the Tools | Options | General page.
Logged
Pages: [1]
« previous next »