Importing an Access Database

[mhadd]

A customer has given me an Access database.  I am attempting to import the schema into EA.  However, every time I try, I receive an error message stating "Database could not be opened".  The database did have a password which I removed.  That did not work.  I then created a new database and imported the tables from the first database.  I received the same error message.  Any clues as to what I can try next?

[«Midnight»]

How are you doing this?

Through Windows, try creating an ODBC or OLEDB data source to open the Access table. During the process you should be given an opportunity to test the connection. If that passes, then use save the data source, again using the Windows dialogs.

Once you've done the above, try using this data source for your import.

David

[Paolo F Cantoni]

Don't forget to check you're using the right version of the JET engine.  What version of Access can you use to successfully open the client's database?

you may need to use Jet 4.0.

Paolo

[mhadd]

I read some earlier posts and so am using Jet 4.0.  I had created and ODBC connection.  I deleted the one I had installed and installed another one but was never given the option to test the connection.  I am still receiving the same error message.  I am using Microsoft Access 2003, SP2.  I can able to view the tables when I open them in Access.

[Paolo F Cantoni]

Access 2003 may not be supported.  Perhaps the Sparxians can confirm.  See if you can save the DB as Access 2000...

HTH,
Paolo

[mhadd]

Well, I tried that as well.  Maybe the database is possessed.

[Aaron B]

I am not aware of any issues with reverse engineering Access 2003 databases.  As long as you have JET 4.0 enabled and have defined the connection correctly, I can't think of any reason why it might fail.  If you can send us a zipped copy of the database to [email protected] (along with a description of the problem) we will see what we can do to help.

[karl]

Hi, I had the same problem running EA6.5 on a new installed Win XP, Office (Access) 2003, ODBC is Version 4.xx, so everything seems ok from the software-side.

The solution was in EA itself (running with JEt 3.5x by default). Choose in the menu Tools-Options-> mark the checkbox "Use JET 4.0" and restart EA.

Karl

[«Midnight»]

Quite correct Karl.

And my apologies to mhadd on this. I definitely should have led off with this, considering the number of times I've suggested that fix in the past. I just didn't think of it, since it's become automatic for me.

Once again this brings up the need for a (comprehensive) Sparx FAQ site, preferably attached to this forum.

It also reinforces the "search before you ask" maxim. Still, for somebody just getting going, how are they to know things like "this is a user forum, so search first" without reading the FAQ?

David