We use Microsoft Access for certain database functions and as most of you already know an Access database can be very grumpy when accessed by an outdated version of Access. In order to control this I have an appliance that can track version number's and update outdated verions if need be. I noted something strange that is happening on all of my workstations.
On a work station if I run wmic and then run the following:
product get name, version
It shows the following version info:
Name Version: Microsoft Office Access MUI (English) 2010 14.0.6029.1000
Yet when I open Microsoft Access and go to File->Help it shows version:
I know the version number that is showing up in Access is correct and the one showing up in wmic is incorrect. This is happening both on Windows 7 and XP machines. Is there a way for me to update the WMI since I rely on that info for version control? Why is it showing such an old version even though it has been updated?
When I look at the version of MSACCESS.exe it shows
14.0.6024.1000, which is an even older version of access! Where exactly is WMIC looking for the version number? Is it a registry key that can be edited?
I have found that the version number at
HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\Userdata\userSID\00004109510090400000000000F01FEC\DisplayVersion seems to be where WMIC is pulling it's verison number from, which makes sense. Where does the Access->File->Help menu pull the version number from then? Does it look at the latest service pack exe for this data?