
Signature
Albert D. Kallal
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
> 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