Microsoft Jet Service Pack 8

  • Thread starter Thread starter Garry Robinson
  • Start date Start date
G

Garry Robinson

I would like to offer a big suggestion for the service
pack 8 of Jet 4.0. Why not post it as an Access service
pack in the Office downloads so that more people receive
the download before they install Access 2003> This way
less people will encounter the the confusing upgrade to
service pack 8 messages as soon as they open Access 2003.

Garry Robinson
Author of Real World MS Access Protection and Security Book
http://www.vb123.com/map/
 
Because it hasn't been tested thoroughly, isn't required for any version of
Access other than 2003, and could cause issues with prior versions of
Access. Microsoft hasn't had a good track record releasing Jet SPs that
don;t cause new problems.
 
Anyone who uses Access 2003 can open either an Access 2002
or a 2000 database. Therefore everyone should be using the
same service pack and if it doesn;t work then its onto
service pack 9. In fact Access 2003 uses the 2002 native
format. Also when Access 2003 opens with either medium or
high macro security, the sandboxmode is turned on and this
can cause all sorts of issues on computers running service
pack 7 or less. If this service pack doesn;t work and
hasn't been tested properly, then it should be fixed as
Access 2003 is going to cause a few problems when used
with existing databases.

Information about Service Pack for Jet
http://support.microsoft.com/default.aspx?kbid=239114

Read about Microsoft Jet Expression Service sandbox mode
http://office.microsoft.com/assistance/preview.aspx?
AssetID=HP010446591033

Garry Robinson
Editor vb123.com
 
Not telling me anything new here. They never did beta testing on this SP
though, and they've pulled too many boners with past SPs.
 
Hi Gary,

Jet 4.0 is a component of Windows and is protected by Windows System File
Protection. As such, it must be released by Windows in order to install
correctly.

Jet 4.0 SP8 was tested and it does work in all version of Access that use
Jet 4.0; this includes Access 2000, 2002 and 2003. While it is true that
Access 2003 is the version that specifically request the use of SP8,
Microsoft typically recomends that the most current service pack of Jet be
installed for use with Access. This recomendation has not change for Jet
4.0 SP8.

In the event that you do discover an issue with SP8, you should report it
to Product Support Services, they will ensure that the the issue is
directed to the appropriate people and work to find a resolution to the
issue. Information about contacting Product Support is available on the web
site. (http://support.microsoft.com)

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
 
OK. I agree that it is a windows service pack and everyone should use WindowsUpdate.com to update the software What I am keen to achieve with this post is that more people find out about this update before they install Access 2003. This especially applies to developers as they need to test access 2000 and 2002 datatabases in sandboxmode before thier users get to them. I have submitted a detailed article on this to smart access and it should end up in the Feb edition


Garry Robinso
Author Real World Microsoft Access Database Protection and Securit
A book by Apres
www.vb123.com/map/ for more details
 
OK. I agree that it is a windows service pack and everyone should use WindowsUpdate.com to update the software What I am keen to achieve with this post is that more people find out about this update before they install Access 2003. This especially applies to developers as they need to test access 2000 and 2002 datatabases in sandboxmode before thier users get to them. I have submitted a detailed article on this to smart access and it should end up in the Feb edition.



Garry Robinson
Author Real World Microsoft Access Database Protection and Security
A book by Apress
www.vb123.com/map/ for more details
Click to expand...

And I thank you for your efforts Garry. While Access 2003 will warn people
of the need to upgrade, it will certainly remove some confusion to have it
installed first since that will eliminate a couple dialog boxes.

You also raise a good point that is important for users who have multiple
versions of Access on their computers. Since the SandboxMode setting is
machine specific, once you turn it on in Access 2003, it will affect Access
2000 and 2002. While there should be no adverse effect on applications in
those versions, it is possible that existing applications may be using
expressions that are now blocked which will start to fail. In those cases,
developers can create wrapper functions in VBA and use those in place of
the blocked expressions that they need to use in thier applications. Most
expressions that are blocked have no legitimate use in Access, but two that
do are CurDir and Environ. You can wrap these by adding code such as the
following to a module in your database:

Public Function CurDir()
CurDir = VBA.CurDir()
End Function

Public Function Environ(Expression)
Environ = VBA.Environ(Expression)
End Function

This will allow the functions to work in a blocked environment.

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Tested? You guys released it without doing a beta!!
Click to expand...

Hi Paul,

Beta testing is only one of the many ways in which Microsoft tests it
products.

Jet SP8 has only a few changes from Jet SP7; those changes were very
specific to Access 2003 and is one of the reasons that Access 2003 requires
Jet SP8. Jet SP7 was extensively beta tested.

If you are aware of any issues specific to Jet SP8, you should feel free to
report them to Microsoft either through Product Support or directly to me.

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top