Paul,
Thanks for taking the time - it's really appreciated. I followed your link
http://www.microsoft.com/downloads/results.aspx?freetext=Microsoft+Access+2002&p
roductID=327F343D-F0D6-4E07-AA53-9656EDB98ADA&DisplayLang=en
and found the following updates:
access2002-runtime-kb813617-client-enu.exe 2719 KB dated 29th April,2003
Access 2002 Runtime Security Patch: KB827430
officexp-kb827430-client-enu.exe 575 KB dated 3rd Sept, 2003
Am confused even further because I'd been looking at:
http://office.microsoft.com/en-us/officeupdate/CD010225581033.aspx
and thought I needed the following updates:
Office XP Service Pack 3 (SP3) for Access 2002 Runtime
Art2002Sp3-kb834693-client-enu.exe 5274 KB dated 9th March, 2004
Office XP Security Update: KB832332 officexp-kb832332-v2-client-enu.exe
1251 kb dated 12th October, 2004
Am not using Multilanguage or SQL so didn't need Access 2002 Update:
KB833857 officexp-kb833857-client-enu.exe 2472 KB dated 23rd March,
2004 or the MultiLanguage update.
Assume that I install Office XP Service Pack 3 (SP3) for Access 2002 Runtime
in lieu of Office XP Service Pack 3 (SP3) when only installing Access Run
Time. Also assumed SP3 is an accumulative patch and includes Office XP
Update: Service Pack 1 (SP-1) and Service Pack 2
To add to all this confusion, I formatted a new drive, installed Windows XP
SP1 (without any patches) and then installed my Runtime & program. Not
another program was installed on the computer. Logged onto the MS website
and ran the Office Update wizard and was told the only update I needed was
Office XP Service Pack for Access 2002 Runtime.
Do we also need to install Jet 4.0 Service Pack 8 (SP8) for Windows XP
(KB829558) and Microsoft Data Access Components (MDAC) 2.8?
It would be lovely to have a definitive answer. Sorry if my reply is longer
than anticipated will understand if you don't get time to reply.
Regards
Di
Paul Overway - 21 Jan 2005 07:02 GMT
You definitely need Art2002Sp3-kb834693-client-enu.exe. As for the others,
they should be updated as part of the OS updates. The updates for Jet are
OS specific...I believe the same is true for MDAC. So, unless you want to
write a fancy installer to determine which OS the user is installing on,
you're better off leaving it to the user to do the OS update. Maybe give
them a notice that they should update their OS.

Signature
Paul Overway
Logico Solutions
http://www.logico-solutions.com
> Paul,
>
[quoted text clipped - 44 lines]
>
> Di
Di Cook - 21 Jan 2005 22:15 GMT
Paul
Thanks so much for your reply. I know why I stayed so long with Access2
runtimes.
Best wishes
Di
> You definitely need Art2002Sp3-kb834693-client-enu.exe. As for the
> others, they should be updated as part of the OS updates. The updates for
[quoted text clipped - 51 lines]
>>
>> Di
Paul Overway - 21 Jan 2005 23:28 GMT
At least there is an update specifically for Access XP runtime. 2003 relies
on a monolithic/bloated SP that is for the entire Office Suite!

Signature
Paul Overway
Logico Solutions
http://www.logico-solutions.com
> Paul
>
[quoted text clipped - 59 lines]
>>>
>>> Di
Di Cook - 22 Jan 2005 08:40 GMT
If I could reliably package an Access 2003 Run Time I'd upgrade to that but
at the moment I've decided to keep all clients who use an OS earlier than XP
on my old Access 2 program (which still works brilliantly - apart from an
intermittent problem with displaying charts - a known issue when OS is XP)
and only clients who have WinXP or better can upgrade to new AccessXP
version. Reading some of the probs with Access 2003 I decided to stay with
Access XP but as we both realise there are issues here as well.
Not too satisfactory.
Thanks so much for taking the time with this Paul - it's really appreciated.
Regards
Di
> At least there is an update specifically for Access XP runtime. 2003
> relies on a monolithic/bloated SP that is for the entire Office Suite!
[quoted text clipped - 64 lines]
>>>>
>>>> Di
Douglas J. Steele - 22 Jan 2005 11:58 GMT
Why do you say "only clients who have WinXP or better can upgrade to new
AccessXP"?
According to http://www.microsoft.com/office/previous/xp/sysreqs.asp the
system requirements for Office XP are Win98 or better. Even Office 2003
doesn't require WinXP or better: it'll run on Win 2000, SP3.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> If I could reliably package an Access 2003 Run Time I'd upgrade to that
> but at the moment I've decided to keep all clients who use an OS earlier
[quoted text clipped - 80 lines]
>>>>>
>>>>> Di
Di Cook - 24 Jan 2005 11:55 GMT
It's a support issue. If your client is remote and, for all you know
doesn't even have internet access, how can you tell them what service packs,
upgrades etc they need if you're catering for multiple OS..
Just thought WinXP was a good close off point.
Regards
Di
> Why do you say "only clients who have WinXP or better can upgrade to new
> AccessXP"?
[quoted text clipped - 89 lines]
>>>>>>
>>>>>> Di