Results 1 to 12 of 12
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Jet 4 SP8 (Access 2003)

    Access 2003 tells me I need to load Jet 4 SP8 if Access is to work correctly.
    I have done this, and checked the properties of Msjet40.dll 4.0.8015.0 .
    They are correct except for the size which is 1,473,000 instead of the posted 1,507,600.
    Any thoughts on why this does not appear to be working. Should I just reload it?

    Regards
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Jet 4 SP8 (Access 2003)

    If you right-click MSJET40.DLL, select Properties, and activate the Version tab, you DO see 4.0.8015.0? Then you should be OK. Perhaps the confusion arises from the unit in which the size is measured: 1,507,600 bytes is almost 1473 kilobytes.

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Jet 4 SP8 (Access 2003)

    As noted, the MSKB article evidently lists the file size in bytes, not KB or MB. To "convert" bytes to KB, MB, or GB, divide bytes by the applicable number of bytes per unit of measurement:

    ? 1507600/1024
    1472.265625 KB

    ? 1507600/(1024^2)
    1.43775939941406 MB

    Determine number of bytes per KB, MB, GB etc:

    ? 2^10
    1024 bytes/KB

    ? 2^20
    1048576 bytes/MB

    ? 2^30
    1073741824 bytes/GB

    When viewing files in WIndows Explorer the size will normally be expressed in KB or MB as applicable.

    HTH

  4. #4
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4 SP8 (Access 2003)

    Thanks Hans
    Yes, I agree about the file sizes.

    So I do have Jet 4.0 SP* OK. So any idea why I still get the message on Access startup and am having problems running some of my programs??

    John

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Jet 4 SP8 (Access 2003)

    Use Start | Search... to find out if you have multiple copies of MSJET40.DLL on your PC. How many do you find, and in which folders?

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4 SP8 (Access 2003)

    One of the security "features" of Access 2003 is that is can always ask for Jet 4 SP8. Have a look at the new issue of Woody's Access Watch (follow the W*W link at the bottom of this page) to see further details about dealing with Access 2003 security. HTH
    Gre

  7. #7
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4 SP8 (Access 2003)

    C:WindowsSystem32MSJET40.DLL

    Only instance

    John

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Jet 4 SP8 (Access 2003)

    Thanks. I think that unkamunka has hit the nail on its head in his reply. Please follow the link he describes to the February 25 issue of Woody's Access Watch.

  9. #9
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4 SP8 (Access 2003)

    Thanks
    I had downloaded Helen's printable version earlier in the week but had not got to action it. I will set up a PDC as soon as.
    However, I suspect that will not remove this Jet Engine message! Helen's article does not mention this, or how to eliminate. Are you able to be more specific?
    Regards

    John

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Jet 4 SP8 (Access 2003)

    Sorry, I don't have Access 2003 and I know nothing about digital certificates.

  11. #11
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4 SP8 (Access 2003)

    Basically, I have yet to come across a way to remove this message. It appears to be an annoyance "by design" - targetted at any developer. I would also suggest that - unless you are comfortable working with VBA instead of the "backwards compatible" functionality - you may wish to select No to the Jet 4 SP8 question.

    BTW does Access still crash if you answer No to the first screen?
    Gre

  12. #12
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet 4 SP8 (Access 2003)

    Hans
    I seem to have a very serious problem. I created a Digital Signiture and applied it to my database. Now I cant open the database. I get the first message about macro's, the second about Jet Engine, then, after a wait, the Microsoft message about sending a report to Microsoft. This has happened on a second database as well. Compact and repair makes no difference. The database is "Disabled" and I can go to Help - About and re-enable the database but it still makes no difference. Only thing is, now, I go straight to the error message about sending a report to Microsoft and the database is disabled again.
    ?????????????????
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •