Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / May 2008

Tip: Looking for answers? Try searching our database.

Access 2003 Runtime and SP2

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tim Lentine - 01 May 2008 15:35 GMT
I need to distribute the Access 2003 runtime with my application (I've got my
installer to the point where it checks for Access 2003 and if it is not found
installs the runtime). However, because we digitally sign the app the target
machine needs to have SP2 installed (at least) otherwise Access crashes when
the mde is opened (I believe this was a bug that was fixed with SP2).

The issue is that I can't seem to locate a version of the Access Runtime msi
which contains SP2 (searching through my MSDN subscription hasn't yielded any
results).

I really would like to provide a seamless install for my users, so I don't
want to have to direct them to Microsoft updates before they try to launch my
application.

Does anyone know if:

A) An Access 2003 Runtime msi installer exists with SP2 included within the
msi?
B) If I can legally distribute Office SP2 as part of my application and
patch the target computer when necessary?
C) If another solution exists to this issue without resorting to having
users install SP2 on their own?

Thanks for any info you might be able to shed.
Tony Toews [MVP] - 02 May 2008 02:35 GMT
>A) An Access 2003 Runtime msi installer exists with SP2 included within the
>msi?

Not to my knowledge.  I would very much like one as well.

>B) If I can legally distribute Office SP2 as part of my application and
>patch the target computer when necessary?

I don't see why not.   However that's rather large as I recall.
Somewhere in the vicinity of 100 Mb.  PITA

>C) If another solution exists to this issue without resorting to having
>users install SP2 on their own?

Not to my knowledge.

What also irks me is that Microsoft Update won't find the A2003
runtime to install Access SP2.    To me this is a rather large
security hole.

Microsoft Update does find A2002 runtime just fine and installs just
an A2002 SP.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Tim Lentine - 02 May 2008 15:11 GMT
Tony,

Thanks for the information, you confirmed what I suspected.  In case you're
interested, I found a post on another forum which describes how to slipstream
SP2 into the Access 2003 Runtime MSI. I stepped through the process this
morning and have tested it out on a couple of times and it appears to work.
I'll have to run a few more tests before we release our installer into the
wild, but so far so good.

http://www.appdeploy.com/messageboards/tm.asp?m=30192&mpage=1&key=&

> >A) An Access 2003 Runtime msi installer exists with SP2 included within the
> >msi?
[quoted text clipped - 20 lines]
>
> Tony
Tony Toews [MVP] - 04 May 2008 05:41 GMT
>Thanks for the information, you confirmed what I suspected.  In case you're
>interested, I found a post on another forum which describes how to slipstream
[quoted text clipped - 4 lines]
>
>http://www.appdeploy.com/messageboards/tm.asp?m=30192&mpage=1&key=&

I'm very, very interested in this.  Many thanks.  Blogged.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Tony Toews [MVP] - 04 May 2008 22:03 GMT
>Thanks for the information, you confirmed what I suspected.  In case you're
>interested, I found a post on another forum which describes how to slipstream
[quoted text clipped - 4 lines]
>
>http://www.appdeploy.com/messageboards/tm.asp?m=30192&mpage=1&key=&

A fellow MVP confirmed that this also worked for SP3 as well as the
SP3 hotfix

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Tony Toews [MVP] - 05 May 2008 11:04 GMT
>>Thanks for the information, you confirmed what I suspected.  In case you're
>>interested, I found a post on another forum which describes how to slipstream
[quoted text clipped - 7 lines]
>A fellow MVP confirmed that this also worked for SP3 as well as the
>SP3 hotfix

He also added that then the Windows Update then found some security
related patches to download and install.  Which I thought was very
interesting.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Patrick Jackman - 05 May 2008 00:15 GMT
Is there a similar "fix" for the Access 2002 runtime? The SP's don't always
update my runtime installs. It seems to be machine dependant.

Patrick.

Tony,

Thanks for the information, you confirmed what I suspected.  In case you're
interested, I found a post on another forum which describes how to
slipstream
SP2 into the Access 2003 Runtime MSI. I stepped through the process this
morning and have tested it out on a couple of times and it appears to work.
I'll have to run a few more tests before we release our installer into the
wild, but so far so good.

http://www.appdeploy.com/messageboards/tm.asp?m=30192&mpage=1&key=&

"Tony Toews [MVP]" wrote:

> Tim Lentine <TimLentine@discussions.microsoft.com> wrote:
>
[quoted text clipped - 23 lines]
>
> Tony
Tony Toews [MVP] - 05 May 2008 05:23 GMT
>Is there a similar "fix" for the Access 2002 runtime? The SP's don't always
>update my runtime installs. It seems to be machine dependant.

This might very well work.  

But you can download the A2002 runtime patch separately
http://support.microsoft.com/?kbid=834693.  A lot more convenient than
the entire Office 2003 SP3 required just for the Access 2003 runtime.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Patrick Jackman - 06 May 2008 17:39 GMT
Thanks Tony, but the problem in my experience is that SP does not always
run. I've just tried it on one system having an XP runtime with MSAccess.exe
version 10.0.4302.0 and got a dialog stating: "The expected version of the
product was not found on your system."

Patrick.

"Patrick Jackman" <pjackman@wimse.com> wrote:

>Is there a similar "fix" for the Access 2002 runtime? The SP's don't always
>update my runtime installs. It seems to be machine dependant.

This might very well work.

But you can download the A2002 runtime patch separately
http://support.microsoft.com/?kbid=834693.  A lot more convenient than
the entire Office 2003 SP3 required just for the Access 2003 runtime.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Tim Lentine - 06 May 2008 19:04 GMT
Have you noticed any commonalities regarding OS, version of Windows
Installer, or anything else on the machines that won't install the SP?

> Thanks Tony, but the problem in my experience is that SP does not always
> run. I've just tried it on one system having an XP runtime with MSAccess.exe
[quoted text clipped - 15 lines]
>
> Tony
Patrick Jackman - 07 May 2008 00:32 GMT
It's a client site. I'll ask.

I should mention that the installs are done with SageKey's scripts for Wise.

Patrick.

Have you noticed any commonalities regarding OS, version of Windows
Installer, or anything else on the machines that won't install the SP?

"Patrick Jackman" wrote:

> Thanks Tony, but the problem in my experience is that SP does not always
> run. I've just tried it on one system having an XP runtime with
[quoted text clipped - 15 lines]
>
> Tony

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.