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 / Developer Toolkits / August 2006

Tip: Looking for answers? Try searching our database.

Package Wizard does not include Service Pack 2

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PBsoft - 31 Jul 2006 07:37 GMT
I developer an ADP with Access 2003 and distributed it with a package created
wih Package Wizard from VSTO 2005.

When I tried to install the package onto my customer computer I noticed that
the installed Access 2003 runtime didn't include Service Pack 2003 for Office
2003.
I searched a lot and asked in an italian newsgroup and finally Giorgio Rancati
told me to visi this page: http://support.microsoft.com/kb/916176/en-us

I red that SP2 files are not included in the package and that I have to run
a chained installation. This means I have to deploy a package increased by
100 MB for each one of my applications.

Do you know any other solutions?

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
Albert D. Kallal - 04 Aug 2006 03:03 GMT
The "term" used to include updates into a product is called
slip-streaming...

So, for example, when windows SP2 came out, you could take a existing
windows install...and slip-stream into this install the SP2 updates. This
new resulting install would then have sp2 included..and you would not need a
separate install. (and the resulting install was not really much different
in size then the original).

It is perhaps possible that the sp2 can be slipstreamed into the runtime
install. I would also like to do this, and have been simply too busy to
research further on how to do this. Anther way around this is to not include
the sp2 update..and let windows update do this for you (I *think* this
works - but, that is not your question). as it stands now, I simply don't
include sp2 with my runtime...

I not seen the instructions around on how to do this, but there is likely a
way....

http://www.broadbandreports.com/faq/msoftapptips/6.3+Additional+Tips+and+Tricks#3867

The above for example gives instructions on how to slip stream sp2 into a
office xp install
the result is a sp2 office xp install (but, again, we are talking about
office 2003) -- it also not clear if this would work for the runtime.

It seems to me, that simply un-packing all of the runtime files into a
directory...running the sp update (as above)..and re-building the cab file
with the updated files would do the trick....  I not done this, nor looked
into even attempting this.

Signature

Albert D. Kallal
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

PBsoft - 07 Aug 2006 12:05 GMT
> The "term" used to include updates into a product is called
> slip-streaming...

Thanks for clarifying, but I already knew the term :-)

> It is perhaps possible that the sp2 can be slipstreamed into the
> runtime install. I would also like to do this, and have been simply
> too busy to research further on how to do this. Anther way around this
> is to not include the sp2 update..and let windows update do this for
> you (I *think* this works - but, that is not your question). as it
> stands now, I simply don't include sp2 with my runtime...

Another solution contists in using a chained installation which does all
the job, installing the update after the installation of the procedure.

> It seems to me, that simply un-packing all of the runtime files into a
> directory...running the sp update (as above)..and re-building the cab
> file with the updated files would do the trick....  I not done this,
> nor looked into even attempting this.

I found nothing about slipstreaming SP2 into Access 2003 runtime, nor I suppose
it could be possible.

Someone told me that simply unpacking the cabinet and overriding the files
is not a good way out.

Anyway, thanks for helping :-)

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolutio
Albert D. Kallal - 07 Aug 2006 12:50 GMT
> Another solution contists in using a chained installation which does all
> the job, installing the update after the installation of the procedure.

yes, but a chained solution as we agreed is rather large...a slipped install
would only be 33 megs..and would install MUCH faster.

> Someone told me that simply unpacking the cabinet and overriding the files
> is not a good way out.

Well, I can't say otherwise right now (I don't have experience in this
regards).
I am sure we all agree that a updated install is preferred, but we just
done have one!!

> Anyway, thanks for helping :-)

Well, I not given up my quest just yet....I just too busy as of now. I will
tackle this eventually...

To be honest, access 2003 runtime is the FIRST version of ms-access that I
would actually feel comfortable in deploying WITHOUT the sp2 updates. There
is not that many bug fixes in the update that applies to ms-access. The
*real* valuable part is that some stability enhancements are in that updated
(based on the crash-test data that ms collects when ms-access craps out on
you -- this is why I always hit send "report" when a application crashes). I
should note that the a2003 runtime without patches has been rock solid for
me, so, I just deploy without the sp2 update. I can't say the same for
access 97, or even a2000...as both REALLY REALLY needed the updates to jet,
and the sr2 updates.

A2003 runtime seems perfectly happy without the sp2 update.....

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

PBsoft - 07 Aug 2006 14:31 GMT
> yes, but a chained solution as we agreed is rather large...a slipped
> install would only be 33 megs..and would install MUCH faster.

I fully agree with you :-)

> A2003 runtime seems perfectly happy without the sp2 update.....

I'll be very happy if I could say the same, but I found a very annoying problem
in Access 2003 that makes SP2 extremely necessary.
The problem arises with nested reports.
When you try to preview or print a report containing another report, you
get a Visual C++ runtime error in MSACCESS.EXE. After applying the patch,
error disappears.
In my applications nested reports are heavily used, so I cannot do without
SP2.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
Albert D. Kallal - 08 Aug 2006 07:01 GMT
> When you try to preview or print a report containing another report, you
> get a Visual C++ runtime error in MSACCESS.EXE. After applying the patch,
> error disappears.
> In my applications nested reports are heavily used, so I cannot do without
> SP2.

I not seen the above., and am not experience this problem....

and I have some reports that have more the one sub-report....

Hum, interesting.....

You could try a de-compile, and then re-compile, and then re-create of the
mde that you deploy with the runtime...it might fix this...

(it could be some type of mild corruption). And, to be honest, the fact that
the SP2 updates fixes this for you is a good thing, and I really don't want
to sit here and say "find" a workaround to installing bug fixes!!! In other
words, that SP2 has fixes in it..and it is there for that reason (I don't
want to stand here say don't install SP2....you should!!).

However, I do find it strange that you are experience this error. I assume
this occurs on more then one machine...and apply the SP2 fixes this on more
then one machine....?

I not seen this come up in the newsgroups (presumably, you installed the SP2
on your dev machine...and the problem went away). Perhaps it was just the
fact that ms-access was install was damaged, and the SP2 update repaired the
ms-access problem, not the fact that no SP2 = crash with sub-reports....

I mean, sub-reports is rather common thing, and I not seen everyone complain
that sub-reports don't work in the runtime...that would MOST certainly come
out in the newsgroups...especially given the amount of time the a2003
runtime been out now...

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

PBsoft - 08 Aug 2006 09:03 GMT
> I not seen the above., and am not experience this problem....
> and I have some reports that have more the one sub-report....
>
> Hum, interesting.....

I omitted to describe clearly the problem.
Please, read this post (it's mine) where also Allen Browne confirmed the bug:

http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/334
abc51a9417d6/bbfd3faaa8a21f83?lnk=st&q=&rnum=4&hl=it#bbfd3faaa8a21f83


The original post was the following (italian newsgroup) ando also here all
people reading could confirm the bug, even with SP1 installed:

http://groups.google.com/group/microsoft.public.it.office.access/browse_thread/t
hread/5ecf476147014c26/e5a5012ddef02984?lnk=st&q=&rnum=10&hl=it#e5a5012ddef02984


Bug has been removed with SP2.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
Albert D. Kallal - 09 Aug 2006 09:09 GMT
Gee, that is interesting....

I actually have some code that sets the top/bottom margin..but, I do it in
the reports on-load..and on-format...not with the
printer object!!..

Regardless...as I said, I can't even *begin* to stand here in any reasonable
fashion and suggest a workaround when the SP2 update fixes your problem. I
am a BIG fan of installing updates, and theses updates also tend to improve
stability...

> I omitted to describe clearly the problem.
> Please, read this post (it's mine) where also Allen Browne confirmed the
> bug:

Thanks for taking the time to share this.

I hope I can return the favour, and build a slipped runtime install....

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

 
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.