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: David W. Fenton on 2 Feb 2010 16:54 "Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in news:5c5fm51tnlptuq31lptani5jkobk83bdnt(a)4ax.com: > "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. My startup logging code records the version of MSACCESS.EXE and MSJET##.DLL. I guess I'd have to update it for A2007 and up to deal with ACE, but I think that the build numbers of those two files ought to be sufficient to determine service pack level. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: Allen Browne on 3 Feb 2010 07:56 FWIW, here's what I use to get the Access version: http://allenbrowne.com/ser-53code.html#GetAccessVersion and the JET version, David: http://allenbrowne.com/ser-53code.html#GetJetVersion That's enough to know the SP, but does not necessarily indicate which particular hotfixes have been applied. -- 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. "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message news:Xns9D13AC0AABF9f99a49ed1d0c49c5bbb2(a)74.209.136.94... > "Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in > news:5c5fm51tnlptuq31lptani5jkobk83bdnt(a)4ax.com: > >> "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. > > My startup logging code records the version of MSACCESS.EXE and > MSJET##.DLL. I guess I'd have to update it for A2007 and up to deal > with ACE, but I think that the build numbers of those two files > ought to be sufficient to determine service pack level. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/
From: David W. Fenton on 3 Feb 2010 18:26
"Allen Browne" <AllenBrowne(a)SeeSig.invalid> wrote in news:H-adnTdUeejv7_TWnZ2dnUVZ_s-dnZ2d(a)westnet.com.au: > FWIW, here's what I use to get the Access version: > http://allenbrowne.com/ser-53code.html#GetAccessVersion > and the JET version, David: > http://allenbrowne.com/ser-53code.html#GetJetVersion > > That's enough to know the SP, but does not necessarily indicate > which particular hotfixes have been applied. No, but there's no central location for that. Basically, you have to look at the details for the hotfix download, which usually lists the files updated and the version numbers. You can then compare the build number for your installation to what the hotfix details article says. BTW, others may not know that the first digit of the build for the Jet DLL indicates the service pack number. Not so for MSACCESS.EXE, though. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |