How To Determine Access Version And Service Pack Number
Wayne
number when a database is opened and flag to the user if they don't
have the latest service pack installed. So far all I can find is:
GetVersion = SysCmd(acSysCmdAccessVer)
which gives me the basic version number but no service pack details.
Is there a simple way to programatically get the service pack details
as well?
MGFoster
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Each version has a version and build number. These numbers are
available on MS' KnowledgeBase web-site. For example Access XP numbers
can be obtained by going to http://support.microsoft.com/kb/307841 and
scroll down to "How to obtain more information about the latest Office
XP service pack." Each SP has a link to a page with more info. On that
page look for a heading like "How to determine whether the update is
installed." Beneath it will be the version/build numbers for the SP.
You can get the version/build numbers from your version of Access using
VBA like this:
With Application
GetVersion = .Version & " " & .Build
End With
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSdyCRoechKqOuFEgEQKphwCgsmeN2QvY+OBYR0+nTvFjlTO1dkcAoIep
1h/QirgPwawIM9cY6zyl5WUJ
=FFt2
-----END PGP SIGNATURE-----
Sascha Trowitzsch
If you don't mind to use an additional tool you may check out this one:
http://www.moss-soft.de/public/AccessVersInfo.zip
It not only tells you which service pack is installed but in case of A2003 also
which hotfixes have been applied.
Ciao, Sascha
"Wayne" <cqdi...@volcanomail.com> schrieb im Newsbeitrag
news:4fdacfca-c46b-47ae...@y13g2000yqn.googlegroups.com...