Windows Installer Problem when running Access 2007 with Office 2003 Professional

How can I stop the Windows Installer from running every time I switch between Access 2007 and Access 2003?

I have Office 2003 Professional SP3 + Access 2007 installed on a XP SP3 machine.
Every time I switch/open either version of Accesss after opening the other version, the Windows Installer runs.

I have searched the web and found/tried several solutions but none of them worked - apparently, the web fixes work for any/all of the Office programs except Access.

Thanks,
Slator
SlatorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DarksquireCommented:
Slator,

From this website,

http://www.generation-nt.com/us/access-2003-2007-always-launches-installer-help-164647841.html

I found the following comment:

It is my understanding that what you are experiencing is normal and
required. The exact same thing happens to me. I believe that part of the
Office 2007 upgrade included a major overhaul of the Access jet database and
so the installer has to run to load the correct drivers for your file. If it
didn't you would end up with a lot of corrupt 2003 databases.
0
SlatorAuthor Commented:
Thanks for the quick response - based on my searching, I am pretty sure you are correct.  Although, your information is the most definitive I have seen so far that there is no "fix".

I have my doubts about the drivers issue because I have had no problems (so far) running both versions of Access at the same time, other than the Windows Installer problem.  However, the end result is the same - "live with it".

Thanks again.

I am going to leave the question open until the weekend - just in case.  If I do not receive any (different) posts by Sunday, I will award the points and close the question.
0
Vadim RappCommented:
What you see is Windows Installer trying to repair the installation, because it figures out that it's broken. The reason it decides that in general case can be found in the event log, where it places the record describing what exactly has not been found, usually file or registry key. So look there first. However, in the specific case of Access, this may be not enough, since Access, when launched, performs its internal verification of the integrity - it calls Windows Installer to verify the installation's integrity, but in this case Installer does not create event log records. The only way to find out what exactly it does not like is monitoring its launch by process monitor or filemon. This is quite nontrivial and tedious investigation, and requires good familiarity with COM entries in the registry, but it can be done, I did it several times.

Another thing to check is the way you launch Access, If self-repair occurs when you launch it by file extension, then check that extension. You can also check my article "How to disable Windows Installer self-repair for a given product" on my website (see my profile).

Finally, as I understand, all 3 quoted statements from the comment quoted above are absolutely wrong. Access 2007 indeed introduced new Access database format, accdb, however it opens all old formats without any problem; it does not require for that any drivers; self-repair on every launch is not normal; Access 2003 and 2007 by design should be able to co-exist on the same machine - the only Office application that can't coexist with its own old version is Outlook, which is prominently announced during the installation.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Rory de LeurConsultant End-User ComputingCommented:
Let try it from another angle, why not give Application Virtualization a try for MS Access 2003
0
Vadim RappCommented:
I would give Application Virtualization a try for MS Access 2007, especially given that "<question author has> Office 2003 Professional SP3 + Access 2007 installed on a XP SP3 machine"
0
SlatorAuthor Commented:
Thanks for the responses - lots of good information to consider.

My conclusion is that (in a practical sense) there is no "fix" - only less than desirable options (for me).

The best for me (if i were to choose a "fix") would probably be the "vadimrapp1" "How to disable...".

Thanks again - I am going to split the points.
0
SlatorAuthor Commented:
Thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Installation

From novice to tech pro — start learning today.