MS Access Runtime 2010

This install is for the 32 bit MS Access Runtime 2010, which allows users who don't have Access or Office Pro installed to work with Access databases.

Download and extract the installation files

• You can get it here: http://www.microsoft.com/download/en/details.aspx?id=10910
• Copy the installer somewhere convenient (eg c:\temp\AccessRuntime.exe)
• Create a folder for the install files (eg c:\temp\AccessRuntime2010
• Extract the setup files to your folder using the /extract:[destination] command line switch

c:\temp\accessruntime.exe /extract:c:\temp\accessruntime2010

• Copy the contents of c:\temp\AccessRuntime2010 to a folder on your WPKG distribution share (eg AccRT)

Config files

We need two XML configuration files - one each to tell the installer to run silently for setup and uninstall.

Silent install configuration

• Create a new XML file called config.xml in the same directory as the setup.exe file - eg \\wpkg_server\wpkg_share\AccRT\config.xml
• Edit with Notepad (other text editors are available), copy the text below and paste into Notepad

<Configuration Product="AccessRT"> 
   <Display Level="None" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" /> 
<Logging Type="standard" Path="C:\Temp\" Template="Microsoft_Access_2010_Runtime_Setup(*).log" /> 
<COMPANYNAME Value="MY COMPANY NAME" /> 
<Setting Id="SETUP_REBOOT" Value="Suppress" /> 
</Configuration>

• Enter your company name (or delete that line from the file)
• Save the file

Silent uninstall configuration

• Create a new XML file called silentuninstall.xml in the same directory as the setup.exe file - eg \\wpkg_server\wpkg_share\AccRT\silentuninstall.xml
• Edit the file in Notepad, copy the text below, paste into Notepad and save

<Configuration Product="ACCESSRT">
<Display Level="none" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" />
<Setting Id="SETUP_REBOOT" Value="NEVER" />
</Configuration>

WPKG package

Here's the XML for the package. We don't want to install the runtime if Office Pro is installed, so I've added a check for Office Pro. If you're using Office Pro it's maybe worth adding the uninstall command to the Office Pro package as an install command before installing Office (ie copy the <remove... /remove> bit from below, paste into your Office Pro package before your first <install... and change the removes to installs). I've not had to do an upgrade yet, so I've left that out...

<package 
    id="AccRT" 
    name="Microsoft Access Runtime 2010" 
    revision="2010" 
    reboot="false" 
    priority="42"> 
 
    <check type="logical" condition="or">
        <check type="uninstall" condition="exists" path="Microsoft Access Runtime 2010" /> 
        <!-- Don't install if MS Office Pro is installed --> 
        <check type="uninstall" condition="exists" path="Microsoft Office Professional Plus 2010" /> 
    </check> 
 
    <install cmd='%comspec% /C start "" /WAIT "%SOFTWARE%\AccRT\setup.exe" /config "%SOFTWARE%\AccRT\config.xml"' >
        <exit code="0" />
        <exit code="1641" /><!-- Success but reboot initiated --> 
        <exit code="3010" /><!-- Success but reboot required -->
    </install>
 
    <remove cmd='%comspec% /C start "" /WAIT "%SOFTWARE%\AccRT\setup.exe" /uninstall ACCESSRT /config "%SOFTWARE%\AccRT\silentuninstall.xml"' >
        <exit code="0" />
        <exit code="1605" /><!-- Product already uninstalled / doesn't exist -->
        <exit code="1614" /><!-- Indicates 'product is uninstalled' --> 
        <exit code="1641" /><!-- Success but reboot initiated -->
        <exit code="3010" /><!-- Success but reboot required -->
    </remove> 
 
</package>

Credits

• Thanks to whoever put together the MS_Office_2010 page
• Thanks to Grubsi for his forum entry: [1]