Ping Allen Browne
in [Help]
|
Prev: Compact/Repair and AutoNumber problem
Next: iexplor is opening with default website when file not found in ms-access
From: Salad on 30 Jan 2010 12:11 Hi Allen: I had a problem with Compact & Repair we discussed in a prior thread. I DL'd the post service pack 3 hotfix you recommended but I could not install/run it on the machine due to security settings. My settings were modified yesterday and I ran it today and the hotfix cured my problems. Hurray! But this begs another question. Do all people that run A2003 also require the hotfix as well? Prior to running the hotfix update I was having a problem with the compact. I asked an employee yesterday to run some compact tests from the same machine. He did so using RemoteDesktop just like I had done. For him, the compact process/tests ran successfully. Due to this I considered the issue a security issue, not an issue with Access or my code. Regardless, the hotfix did its job. But I'm guessing the hotfix is machine dependent. I don't know if others will/do suffer the same problem in other A2003 applications they run. One last question. At your site, I know you have code to determine the version used in Access. Is there a way/code to determine if it has the hotfixes applied as well? Thanks for your assistance and advice.
From: Allen Browne on 30 Jan 2010 19:07 I would strongly recommend this particular hotfix be applied to all the A2003 SP3 machines, as it addresses several issues: http://allenbrowne.com/bug-Access2003SP3.html The version info code is in: http://allenbrowne.com/ser-53code.html That's the code for the Splash screen utility: http://allenbrowne.com/ser-53.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Salad" <salad(a)oilandvinegar.com> wrote in message news:uvedneCASJi19fnWnZ2dnUVZ_gadnZ2d(a)earthlink.com... > Hi Allen: > > I had a problem with Compact & Repair we discussed in a prior thread. I > DL'd the post service pack 3 hotfix you recommended but I could not > install/run it on the machine due to security settings. > > My settings were modified yesterday and I ran it today and the hotfix > cured my problems. Hurray! But this begs another question. Do all > people that run A2003 also require the hotfix as well? > > Prior to running the hotfix update I was having a problem with the > compact. I asked an employee yesterday to run some compact tests from the > same machine. He did so using RemoteDesktop just like I had done. For > him, the compact process/tests ran successfully. Due to this I considered > the issue a security issue, not an issue with Access or my code. > > Regardless, the hotfix did its job. But I'm guessing the hotfix is > machine dependent. I don't know if others will/do suffer the same problem > in other A2003 applications they run. > > One last question. At your site, I know you have code to determine the > version used in Access. Is there a way/code to determine if it has the > hotfixes applied as well? > > Thanks for your assistance and advice. >
From: Salad on 30 Jan 2010 20:31 Allen Browne wrote: > I would strongly recommend this particular hotfix be applied to all the > A2003 SP3 machines, as it addresses several issues: > http://allenbrowne.com/bug-Access2003SP3.html I will inform them. Whether they act on it or not is debatable. > The version info code is in: > http://allenbrowne.com/ser-53code.html > That's the code for the Splash screen utility: > http://allenbrowne.com/ser-53.html > Yes, I have your code for my splash screen. If I do Help/AboutAccess from the database window I see "Microsoft Access 2003 (11.8204.8221) SP3." If I run your code GetVersion() I see 11.0.8204.0. Can one determine the current service pack numbers or hot fix number in code? I can't recall if I did apply the hotfix to my computer. If I did, it was a while back.
From: Allen Browne on 31 Jan 2010 05:50 My code actually examines the version of msaccess.exe. I'm not sure what Microsoft is reporting on, but if a service pack updated other files but not msaccess.exe, they may report differently. Service packs are cumulative, but hotfixes are not. I don't see a way to determine what hotfixes are applied, other than by checking the version of files that are specifically described in the hotfix. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Salad" <salad(a)oilandvinegar.com> wrote in message news:iuSdnZvuO7PvQPnWnZ2dnUVZ_jqdnZ2d(a)earthlink.com... > Allen Browne wrote: > >> I would strongly recommend this particular hotfix be applied to all the >> A2003 SP3 machines, as it addresses several issues: >> http://allenbrowne.com/bug-Access2003SP3.html > > I will inform them. Whether they act on it or not is debatable. > >> The version info code is in: >> http://allenbrowne.com/ser-53code.html >> That's the code for the Splash screen utility: >> http://allenbrowne.com/ser-53.html >> > Yes, I have your code for my splash screen. If I do Help/AboutAccess from > the database window I see "Microsoft Access 2003 (11.8204.8221) SP3." If > I run your code GetVersion() I see 11.0.8204.0. Can one determine the > current service pack numbers or hot fix number in code? > > I can't recall if I did apply the hotfix to my computer. If I did, it was > a while back. > > >
From: Tony Toews [MVP] on 1 Feb 2010 22:01
"Allen Browne" <AllenBrowne(a)SeeSig.invalid> wrote: >I don't see a way to >determine what hotfixes are applied, other than by checking the version of >files that are specifically described in the hotfix. Likewise. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/ |