Deployment of Office XP SP3 for Access 2002 Runtime

[Carol King]

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

[Carol King]

Update to Post: It looks like that file name is
now "Art2002Sp3-kb834693-client-enu.exe" instead
of "Art10Sp3-kb834693-fullfile-enu.exe"

Carol King

-----Original Message-----
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
.

[karenhart]

Thank you for saving my life, carol! By the way, great songwriting, too :-)