asked on

problem with access 2010 runtime in solution package

I have a simple access 2010 app thet I want to distribute to users who don't have access. I have windows 7.

I used the package wizard to make a package includint my mde together with access 2010 runtime.

When I install the app on the user's computer (windows 8), the access runtime does not install even though the app does.

I installed access 2010 runtime manually on that computer and applied service pack 2. It does install. However, when I click on the first button in the app, I get an error message saying it cannot use my VBA code. Yhe vba code worked on my computer, though.

What can I do?

Thanks in advance

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gite

ASKER

Thank you very much for your answer.
I checked for the references and I think there should be no problem. You wil find them attached.
I will also add the following to my solution package

Root = CU

Key = Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Ma-Validation

Name = Path

Value = C:\_MA

where Ma-Validation is my application name and C:\_MA is where it will be installed.
My application will not be installed nor use datata in a subfolder of C:\MA not on a network. However my app will communicate from time to time with an SQL Server on a remote server. That connexion to SQL Server was tested on my machine.

Please confirm that my references do not need any specialin sht package and that those comments should solve the Trusted Center problem.
Also, I don't understand how that could explain why Acces runtime was not installed with the package, while it was included into it.
References.JPG

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gite

ASKER

Thanks a lot. It worked

Scott McDaniel (EE MVE )

Author indicated the comments worked.

Gite

ASKER

I succeeded in implementing my package using the package wizard to set up the reg keys.
However, I'm now trying to imlement on a XP computer the same way, but I stil get an error message saying it cannot use my VBA code.
How do I settel that problem on XP?
Thanks

Scott McDaniel (EE MVE )

Please ask this as a new question.