Read Service Pack number by code

[Midsomer]

After getting the maxlocksperfile error, I find out that this is a
problem fixed in SP1 so I want to read the SP number in VBA code and
advise the user that there is a service pack that needs installing.

I've tried Application.Version, Application.Build,
Application.ProductCode.

Anyone know how to read the SP number? Thanks.

 

[Midsomer]

I should have stated this is an Access 2007 problem

 

[Douglas J. Steele]

I would assume that the technique outlined in
http://www.mvps.org/access/api/api0065.htm at "The Access Web" would be
applicable for Access 2007 as well. You'd just have to figure out the
appropriate version information, since it isn't posted there.

 

[Midsomer]

Thanks, Doug
Your link (Get Version of Office Exes (detecting Office patches))
returns a result that seems to tally with Application.Version and
Application.Build. I'll try and check if .Build is different between
SP1 and SP2 as that would provide a convenient way of detecting if
Access has the latest upgrades.

Midsomer

 

[David W. Fenton]

m:

Your link (Get Version of Office Exes (detecting Office patches))
returns a result that seems to tally with Application.Version and
Application.Build. I'll try and check if .Build is different
between SP1 and SP2 as that would provide a convenient way of
detecting if Access has the latest upgrades.

My experience with MS version numbers is that the first digit of the
build number is the service pack level. The rest of the digits
represent various versions within a service pack level.

 

[Tony Toews [MVP]]

Your link (Get Version of Office Exes (detecting Office patches))
returns a result that seems to tally with Application.Version and
Application.Build. I'll try and check if .Build is different between
SP1 and SP2 as that would provide a convenient way of detecting if
Access has the latest upgrades.

BTW I think the A2007 SP1 runtime has a newer exe version than A2007
SP1 retail. So you'll have to account for that difference as well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Midsomer]

Thanks to you all. Your tips are really useful.

Office 2007 has only reached SP1 according to our IT team, but I've
noted what is returned by Application.Version and Application.Build
and will compare these values with those from the next update. To
know that Acc2007 runtime has a newer version than the retail
version... there's knowledge for you!

Midsomer