If you are a Microsoft Access developer and are about to install Microsoft Office 2007 on a computer that already has an earlier version of Microsoft Access, read these instructions carefully or you may delete your old versions of Access. This article is important because the Office 2007 setup wizard deletes old versions as a matter of course.
Tip: It would probably be a good idea to add a Restore Point using the Help and Support Centre of Windows XP before starting, if this is an option available to you.
Why should you care?
If you are a developer and had to support somebody using an Access 2002 database, you really should do this using Access 2002 rather than Access 2007. If you use Access 2007 you will have a lot of trouble with VBA references and you really won't know whether your software will work until your user tells you that it is working (in their version of Access 2002).
The rest of this article will assume that you want to keep your older versions of Access/Office.
Do not press the Upgrade button
The first screen you will see after the registration form allows you to upgrade or customize your installation of Office 2007. If you are a developer you should always choose customize as it is good to know what you are installing. Anyway please pick Customize, failure to do so will wipe out your old versions of office.
The first form that affects your old Office program installations
These following details are the Microsoft help notes, when clicking on the ? icon from the form shown above
Choose Customize: When you pick the customise button, you first will see the upgrade Tab (shown below)
If you choose Keep Previous Versions, be aware that old versions of Outlook will be removed. At this stage, decide if you want the new Outlook or your old one. If you use Outlook automation as part of what you deliver to a client, you need to select the installation options Tab.
If you like the version of Outlook that you are using and are not sure that the new version will be an improvement, you need to choose the Installation Options Tab. If you want your old Outlook program, unselect Outlook 2007 as shown below.
Ensuring that your old version of Outlook is not replaced
If you really only want to test out Access 2007, don't install the other programs such as Word and Excel at all. It is easy to install them later. Word especially can cause problems where older versions of Outlook are concerned.
It is very important that you look at this option, as you can see from the setup shown below, all the files were about to be installed in the same folder as my Office 2002 software. Installing in your old office folder will make life more confusing when you are trying to reference older versions of Excel or Word in VBA.
The workbench for Microsoft Access allows you to define which version of access you are going to use to open a database. If you want to ensure that you are running the same software as your clients, you really need to open the right version of Access every time.
For full details of the Microsoft Access Workbench, and details of where to download a trial version of the Workbench please view the following article: