Deployment of Office XP SP3 for Access 2002 Runtime

From: Carol King (anonymous_at_discussions.microsoft.com)
Date: 10/07/04


Date: Thu, 7 Oct 2004 04:54:47 -0700

I thought I'd post an issue (and resolution) I had with
the SP3 for Access 2002 Runtime packaging in case it will
help anyone else that encounters the same problem.

Issue was: I downloaded Office XP Service Pack 3 for
Access 2002 Runtime on my development machine, and then
used the Packaging Wizard to package and deploy my
database application to a deployment machine. After
installing the application on the deployment machine, I
recieved the "Error 3075 function is not available in
expressions in query expression" when trying to open my
installed application. This related to the Date()
function that I use on forms and in VB code in the
application.

Resolution: That Date() function has worked
successfully for years of deployment, but was now
disabled if the deployment machine had not also been
updated to Office XP Service Pack 3 for Access 2002
Runtime. This required that I include the file
Art10Sp3-kb834693-fullfile-enu.exe in the deployment
package and run that file after installing the
application. The download for this file can be found in
Microsoft Article 834693. For some reason, the Runtime
that is packaged using the packaging wizard does not
completely update the Runtime on the deployemnt machine
to Service Pack 3 (even though the packaging machine has
been updated). We tried completely uninstalling any
previous versions of Runtime on the deployment machine
and then installing the package and that did not help.
The "Art10Sp3-kb834693-fullfile-enu.exe" file has to be
run on each deployment machine after installing a package
from a machine that has been updated to SP3 for Runtime.

Hope this helps somebody else!

Carol King



Relevant Pages

  • Re: Installing kernel-.src.rpm under my own build root
    ... packaging identity and do all packaging under the system default packaging tree. ... "Installing" a source RPM is conceptually the same as unpacking a source tarball, in the sense that it's unpacking an archive that must then be passed through translators to convert it into a binary object suitable for installation. ... I'm installing kernel source because I want to fool with the stacks option needed by the ndiswrapper driver, which in turn may help ndiswrapper to work correctly with the Buffalo AirStation WLI-CB-G54A wireless network PC card I want to pop into my laptop. ...
    (Fedora)
  • Re: Can anyone please help me to package my Acc 2000 program?
    ... the the target program folder,where it was installed.Even when i unhided all ... And this is what im looking for.This method of packaging or installation ... that the main mdb file be convertedafter installing and ... > that when you package your app, you also package any dependencies your app ...
    (microsoft.public.access.forms)
  • Re: py2exe/distutils: how to include a tree of files?
    ... "data_files" is documented in the official distutils documentation. ... building, installing, and packaging (source and py2exe). ...
    (comp.lang.python)
  • Re: Installing kernel-.src.rpm under my own build root
    ... Which I want to install in the rpm build root in my home directory (so it ... For a kernel build, ... identity and do all packaging under the system default packaging tree. ... "Installing" a source RPM is conceptually the same as unpacking a source ...
    (Fedora)
  • Re: ./configure command
    ... would have some mysterious problem with installing a non-packaged ... packaging packages as rpms on rpm based systems. ... will generally find someone who can provide the spec file to be included ...
    (Fedora)