Can a mde runtime based on access 2003 on computer with access 2007 installed

I need to run a software package that is bundled with the Access 2003 runtime package on an XP computer that already has Access 2007 installed.  I know that this application is not Vista compatible.  

:After both are installed
Access 2007 begins the first time configuration (and seems to complete it) each time the program is opened.  
2003 runtime app prompts for password and accepts but then fails to load indicating that the publisher certificate is not installed and quits without prompting to install the certificate.  (This happens even if Access 2007 security is set to minimum.)
The same runtime installed and runs on XP computers with Access 2003 installed and did prompt to install the certificate on first run.  The run-time publisher's certificate is displayed in the list of installed certificates for all Office 2003 applications.
LVL 1
cathynAsked:
Who is Participating?
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.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Nope nope nope nope nope.

You have to do one of two things:
(1)  Install Access 2003 runtime on that pc, and in the shortcut to your Access 2003.mde file specify the Access 2003 executable to run.
       "c:\Program Files\Your version of 2003\msaccess.exe" "c:\YourAppPath\YourApp.mde"
(2)  Find the .mdb that created this Access 2003.mde, upgrade it to Access 2007, then make an Access 2007.mde out of it.

Not sure about the certificate aspect of it, other than (2) would likely require a new certificate.

Hope this helps.
Jim
0
cathynAuthor Commented:
The startup icon used for the runtime app does reference the 2003 runtime
Target:
  "C:\Program Files\Microsoft Access Runtime\OFFICE11\MSACCESS.EXE" /excl  /runtime  /profile "CRS5"  /wrkgrp "C:\AccessApps\CRS5\E5SYSTEM.MDW" "C:\AccessApps\CRS5\E5CRS APP.MDE"
Start in:
  C:\AccessApps\CRS5

Office 2007 is installed in the normal location.  Above installations are different and are the default for the runtime app.

Are 2003/2007 incompatible on the same machine regardless of icon path, etc?
If so, would uninstalling Access 2007 (but not the rest of the Office 2007 suite) and reinstalling the 2003 runtime program be an option?  Do you know if  Excel 2007 or other Office programs still compete with a 2003 runtime?  
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
2003/2007 should coexist fine on a pc, at least it does on my dev laptop at home, although I have no idea if this is the case regarding certificates.

I'll see if I can get an Access expert knowledgeable on certificates to post in this question.
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

cathynAuthor Commented:
Thanks, Jim.

If they can coexist, can the Certificates snap-in in mmc be used to manually install the publisher certificate?  

Since I'm going to have to talk the user through this over the phone I'd rather not try it if there's no chance it will work.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Yes, this can work ... but what type of certificate did you use? Is this a commercial code signing certificate? If not, then you really can't get this to work.

How did you sign the Access app? Generally this is done in the VBA edit window ... is this what you did?

What did you use to package the application? Did you also sign the install package?



0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Note that you can install the certificate using Internet Explorer ... in 7.0, click Tools - Content - Certificates - Import.

If you're trying to avoid the security messages, note that the enduser machine will need to have Jet SP8 installed as well, and the user will have to enable "sandbox" mode ... this is done by answering the questions when the app is initially installed. See this link for more info:

http://office.microsoft.com/en-us/access/HA011225981033.aspx#0
0
cathynAuthor Commented:
I passed on inaccurate information (scream!), sorry.  Turns out Office 2007 is instaled without Access 2007 however a third runtime is installed using Access 2007 runtime and it's installation created an icon to Access 2007.  Explains why it acted each time as if it hadn't been opened before.  Amazed that it opened as far as it did.  So machine has 3 Acccess runtime applications, each a different version of Access.

When I asked the user to attempt to install the certificate via IE7 was told she had no such menu option.  (I've blocked IE7 upgrade on my machines because of a known software conflict.)

After unsuccessfully attempting to install the full version of Access 2007 (hoping would enable publisher certificate store), we made the conflict a non-issue by installing the problem run-time on a different computer.  (I wasn't acdtually at the computer and the person running the install was unable to relay what the installation error was.)

Thanks so much for all your help!
0
cathynAuthor Commented:
Since jimhorn clarified that the different versions should coexts (although I gave up attempting to do so) and neither of LSM's comments were applicable in this case, I'm awarding all points to jimhorn.

Thanks again.
0
cathynAuthor Commented:
Thanks, Jim!  Your help has reduced the frustration of trying to help someone remotely!  Their regular tech person had given up and thrown it in my lap because I had been able to make this mandatory program work in my office.  I'm impressed with your ability to do this over and over!  Thanks.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
0
cathynAuthor Commented:
LSMConsulting --   Thanks for your expertise on certificates.  I'll refer to your suggestions in future instances!  Thanks!
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
Microsoft Access

From novice to tech pro — start learning today.