Results 1 to 12 of 12
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Jet Service packs (Access 2000)

    I have the SP5 for Jet 4.0. (jet40sp5_w2k.exe) Is there a newer version and, if so, where can I download it from.
    I have just searched the Microsoft site and found the latest one there (found by the Microsoft search engine) is older than this one!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Jet Service packs (Access 2000)

    As far as I know, SP5 is the latest service pack for Jet 4.0.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet Service packs (Access 2000)

    Thanks, I'd wondered as it is now quite some time since it's release.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Jet Service packs (Access 2000)

    It may have something to do with the fact that Microsoft is not planning to release any further enhancements to Jet. See http://msdn.microsoft.com/library/default.....asp?frame=true for further details. Look under Obsolete Components for DAO and Deprecated Components for Jet.
    Charlotte

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

    Re: Jet Service packs (Access 2000)

    There is a Service Pack 6 (SP6) for Jet 4.0 out. I think it was released only recently. It can be downloaded by going to MSKB Article Q239114. (I chanced upon this article while searching for something else...)

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Jet Service packs (Access 2000)

    How does one tell what SP number one's JET is?

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

    Re: Jet Service packs (Access 2000)

    There's no simple (obvious) way - if you type ?DBEngine.Version in the Immediate window you get the informative reply, 3.6 (ie, DAO 3.6). To determine which version of Jet you have, locate file MSJET40.DLL, (usually in WindowsSystem folder (WIN 9X)), right click, select Properties, then Version tab. The file version number will be listed. Compare this number with file version numbers provided in the MSKB article referenced above under heading "Jet 4.0 Service Pack History":

    SP3 4.00.2927.4
    SP4 4.0.3714.7
    SP5 4.0.4431.1
    SP6 4.0.6218.0

    There apparently was no SP1 or SP2.

    NOTE: I had problem after installing SP5 with some databases that had been secured using a workgroup file created in an earlier version of Jet - described in MSKB Article Q301474. You may want to check this out if applicable in your case. I haven't installed SP6 yet; the MSKB article for update lists "fixes" SP6 is supposed to fix but this issue was not listed.

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

    Re: Jet Service packs (Access 2000)

    This article was very informative - there's no ambiguity, DAO is OBSOLETE, while JET is "deprecated", meaning not obsolete now, but probably will be under MS's ".NET" master plan. Yikes - I guess this means I gotta learn ADO?? <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Jet Service packs (Access 2000)

    ADO isn't all that bad, although it takes getting your head around an entirely different object model with just enough similarities to confuse you thoroughly. The real implication is that MDBs are on their way out, to be replaced with the MSDE, and *that* is a whole 'nother database entirely! Better start learning SQL Server while you're at it.
    Charlotte

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Jet Service packs (Access 2000)

    They've updated it within the last month. I just checked the March Technet database, and that version of that article referenced SP5.
    Charlotte

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

    Re: Jet Service packs (Access 2000)

    I noticed at bottom of MSKB article it sez:
    <hr>Last Modifed Apr 17 2002 2:42PM<hr>
    which suggests to me that this may be the date the new update was actually released, ie, same date original question was posted....

  12. #12
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Jet Service packs (Access 2000)

    Thanks.

Posting Permissions

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