MSJET35.DLL error on new installation

[EARookie08]

Folks, I need some advise.  I just installed EA on my Windows XP SP2 laptop.  It has MS Access 97 and 2003 previously installed.  After EA installation, I tried to create a new project.  When I clicked Save in the New Project dialog, I received an EA dialog that said:

An Error has Occurred: Incorrect version of the .DLL file 'MSJET35.DLL' was found.

I received the same error when I tried to open the EAExample project.  Rebooting didn't clear up the problem.  As far as I can tell, the version of MSJET35.DLL is the same as I've been using with Access 97 and 2003.  

Any ideas on how to remedy the problem?  Please share them.

Thanks in advance,
EARookie08

[mrf]

Process Explorer reports the following on my machine:

Description: Microsoft Jet Engine Library
Version: 3.51.2723.0000
Time: 17/10/2000 6:59 AM
Path: C:\Windows\systems32\MSJET35.DLL

Do the build versions/dates look any different on your machine? If so try downloading the redistributable version of the library and copying it to the above path (backing up anything that was already there of course :p)

[«Midnight»]

Or, you might try setting Jet 4.0 as your default driver. To do this open EA - use the Windows Start menu to open EA without opening a project - and then open the Tools | Options | General (the Options default) dialog.

Check the Jet 4.0 box, then close the dialog and exit EA. Upon restarting EA the new setting will take effect and thereafter be the default. [Of course, you can always revert this by following the same process and clearing the option.]

Do you now get the error?

[AnotherEARookie]

Thanks Midnight! You're a god-send.. worked for me  

This problem should be considered in future versions of Sparx EA. Simply build a routine to check for compatibility of an old project, reset to Jet 4.0 if necessary, exit and restart.

Jj

[«Midnight»]

Off hand I don't know of any way to set the Jet 4.0 from the API.

I have requested that the EA default - as in, the option that installations are first set to - be Jet 4.0, since Jet 3.51 has now passed its end-of-life MS support date (10 years from release around the beginning of 1997).

Sparx did respond that they'd take this under advisement, but to my knowledge no such change has yet occurred. NOTE: I have not tried a full installation, without prior registry settings, since well before I made the suggestion; Sparx may have made the revision. Note as well that I made this suggestion recently, and Sparx might not want to make any such change between versions (major or minor as the case might be).

David

[AnotherEARookie]

fyi.. the version I installed is the trial version 7.1.833 (Build: 833) dated 2008, which I downloaded today from their website. Should be the latest. We'll just have to sit tight, wait and see...

Thx,
Jj

[«Midnight»]

You are definitely up to date then.

Please note that while the installation default may - you are in a better position to test this than I - still be 3.51, EA will respect any change you make afterward. To be absolutely clear, if you change the default to Jet 4.0, EA will continue to use that setting thereafter.

NOTE: The Jet version setting will also be respected by the API, which will use whatever default was most recently set (by the user or the original installation otherwise).

In case anyone is not sure, you can change this by hand. Start EA - you don't need to open a project - and from the main menu choose Tools | Options. The General dialog page, which is the default, has an option to use Jet 4.0. It is cleared (i.e. not set) by default. If you want to use Jet 4.0 - I strongly suggest you do so - check the box. Note that you must exit EA completely afterward. The new setting will take effect the next time (and subsequent times) you start EA.

HTH, David