Install Access 2007 after initial Office install.

TJ311 · #1 09-17-2009, 07:22 AM

In our organization we were not ready to switch to Access 2007 at the same time we were upgrading to Office 2007 so I originally created a package to deploy Office Enterprise 2007 to our company. Months later, we're now ready to upgrade from Access 2003 to Access 2007 but I'm having some issues with the upgrade.

I used the OCT initially and am trying to find a silent way to install just Access 2007 and remove Access 2003 without affecting our users much. I've "almost" got it. Instead of using the OCT again, I'm creating a custom .xml which does get Access 2007 installed but doesn't remove 2003. Is there something I can put in the xml to force uninstall or remove 2003?

Here's what my xml looks like now:

Code:

<Configuration Product="Enterprise">    

    <Display Level="none" CompletionNotice="yes" SuppressModal="yes" AcceptEula="yes" />     
    <PIDKEY Value="XXXXXXXXXXXXXXXXXXXXXX" />
    <USERNAME Value="User" />
    <COMPANYNAME Value="Our Company" /> 

    <!--
    ################################################################
    2007 OFFICE SYSTEM
    INSTALL NEWER VERSIONS
    ################################################################
    -->

<!-- Remove Access 2003 -->
    <Setting Id="REMOVEPREVIOUS" Value="ACCESSFiles" />

<!-- Access -->
    <OptionState    State="Local"     Children="Force" Id="ACCESSFiles" />

<!-- Excel -->
    <OptionState    State="Local"     Children="Force" Id="EXCELFiles" />

<!-- Groove -->
    <OptionState    State="Local"     Children="Force" Id="GrooveFiles" />

<!-- InfoPath -->
    <OptionState    State="Local"    Children="Force" Id="XDOCSFiles" />

<!-- OneNote -->
    <OptionState    State="Local"     Children="Force" Id="OneNoteFiles" />

<!-- OneNote :: Integration :: Internet Explorer -->
    <OptionState    State="Local"    Children="Force" Id="OneNoteToIEAddin" />

<!-- OneNote :: Integration :: Windows Mobile devices -->
    <OptionState    State="Local"    Children="Force" Id="OneNoteMobile" />

<!-- Outlook -->
    <OptionState    State="Local"     Children="Force" Id="OUTLOOKFiles" />

<!-- PowerPoint -->
    <OptionState    State="Local"     Children="Force" Id="PPTFiles" />

<!-- Publisher -->
    <OptionState    State="Absent"    Children="Force" Id="PubPrimary" />

<!-- Word -->
    <OptionState    State="Local"     Children="Force" Id="WORDFiles" />

<!-- Visio Preview -->
    <OptionState    State="Local"     Children="Force" Id="VisioPreviewerFiles" />

<!-- Shared -->
    <OptionState    State="Local"     Children="Force" Id="SHAREDFiles" />
<!-- Shared :: Proofing :: Deutsch -->
    <OptionState    State="Absent"    Children="Force" Id="ProofingTools_1031" />
<!-- Shared :: Proofing :: Ukranian -->
    <OptionState    State="Absent"    Children="Force" Id="ProofingTools_1058" />
<!-- Shared :: Microsoft Office Download ActiveX control -->
    <OptionState    State="Local"    Children="Force" Id="TCDRegistration" />

<!-- Tools -->
    <OptionState    State="Local"     Children="Force" Id="TOOLSFiles" />
<!-- Tools :: System Information -->
    <OptionState    State="Local"    Children="Force" Id="MsInfoFiles" />
<!-- Tools :: Integration :: Office Server -->
    <OptionState    State="Local"    Children="Force" Id="OSESupp" />
<!-- Tools :: Integration :: Internet Explorer -->
    <OptionState    State="Local"    Children="Force" Id="RefIEBarFiles" />
<!-- Tools :: WebDAV -->
    <OptionState    State="Local"    Children="Force" Id="WebDriveFiles" />

<SetupUpdates
   CheckForSUpdates="Yes"
   SUpdateLocation="\\trusty\public\Office\Updates"/>
<Setting Id="SETUP_REBOOT" Value="IfNeeded" />

        

</Configuration>

Thanks in advance for ANY help!

wcb · #2 01-18-2010, 11:33 AM

Did you figure this out? I have the same problem, except I created an MSP to add access, but I do have the option to remove Access 2003 selected but it is not removed.

TJ311 · #3 01-18-2010, 12:04 PM

Actually I did figure this out. It might be a little clunky but it works well. In our environment, we have Office 2007 Ent installed but we are using Access 2003. I was trying to remove Access 2003 and replace it with Access 2007. Here's how I did it:

I first wrote a batch file that will check for MSACCESS.EXE in the Office11 folder, which if exists will uninstall Office 2003 products. Once finished it will kick off the network-based install for Office 2007 calling the custom.xml I created that will only add Access 2007. I did not use an .MSP file.

The batch file looks like this:

Code:

@echo off
color 17
title Microsoft Office Replacement Batch File
echo .
echo .
echo Checking for older versions of Microsoft Office.....
ping -n 5 127.0.0.1 >NUL
if exist "%PROGRAMFILES%\Microsoft Office\OFFICE11\MSACCESS.EXE" goto Uninstall
goto Install
:Uninstall
cls
echo Older version of Microsoft Office detected.
ping -n 3 127.0.0.1 >NUL
echo Let's get rid of that.
ping -n 3 127.0.0.1 >NUL
echo .
echo .
cls
echo Uninstalling Office 2003. Please wait.....
Start /wait Msiexec.exe /x {90110409-6000-11D3-8CFE-0150048383C9} /qr
:Install
cls
echo Older version of Microsoft Office not detected.
ping -n 3 127.0.0.1 >NUL
cls
echo We'll install Microsoft Office 2007.
ping -n 3 127.0.0.1 >NUL
echo .
echo .
echo Running Office 2007 Installer. Please wait.....
Start /wait \\myserver\office\install\setup.exe /config \\myserver\office\install\customconfig.xml
echo .
echo .
echo .
cls
echo All Done! You should restart your computer immediately!
echo Press Enter to exit.
Pause>nul

The XML I created looks like this:

Code:

Configuration Product="Enterprise">    

    <Display Level="basic" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" />     
    <PIDKEY Value="YOURPRODUCTKEYGOESHERE" />
    <USERNAME Value="User" />
    <COMPANYNAME Value="Our Company Name" /> 

    <!--
    ################################################################
    2007 OFFICE SYSTEM
    INSTALL NEWER VERSIONS
    ################################################################
    -->


<!-- Access -->
    <OptionState State="Local" Children="Force" Id="ACCESSFiles" />

<SetupUpdates
   CheckForSUpdates="Yes"
   SUpdateLocation="\\myserver\Office\Updates"/>
<Setting Id="SETUP_REBOOT" Value="IfNeeded" />

        

</Configuration>

I know the batch file is a little cheesy and can be modified but it works for us. I hope this helps.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
new install of 2007	pete	Office	3	02-05-2011 09:38 PM
can't re install Office 2000	sheim	Office	0	07-29-2009 06:49 AM
Can I Remove Old Office when install new version	tutordude	Office	2	07-13-2009 07:15 AM
How can I un-install MS Office 97?	burnselk	Office	2	12-06-2008 09:23 AM
access runtime application will not install	markjean	Office	1	12-06-2005 02:15 AM