[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access 2010 Trust Question

Posted on 2011-10-07
5
Medium Priority
?
469 Views
Last Modified: 2012-08-14
Hello,

I'm very new to Access 2010 although I'm familiar with Access 2K.

I've just developed my first Access 2010 applicaiton and provided it to a user who is using the 2010 runtime.
When the user tries to open the applicaiton, they get a blank screen.

I suspect its a trust problem, but being new to 2010 I'm not sure how the user sets up an application to run for the first time.
In order for me to run my own application, I had to go into my software and set up the dirrectory as trusted.
Since the user only has the runtime, we don't know where to go or what to do.

Can you help?

PC
0
Comment
Question by:pcalabria
  • 2
  • 2
5 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1336 total points
ID: 36932580
You can add the Registry keys manually.  We just went through this recently:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27326491.html?cid=1135#a36600039
There is reghacking for the trust center settings available.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27309981.html?sfQueryTermInfo=1+10+30+center+nick67+trust

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\TrustedLocations\SomeName]
"Path"="C:\\Path To Your Folder"
"AllowSubfolders"=dword:00000001
"Description"="TrustedLocation1"

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1336 total points
ID: 36932592
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 664 total points
ID: 36932593
You can add the necessary registry settings to add a new Trusted Location to the client machine. The keys you must add/set are here:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location1
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) = "Full path to your database"

Note the "Location1" value - this value MUST BE UNIQUE on the machine, so if you should change that to something like AppName_TL, or something that should be unique.

You can provide this to the end user as a standard Text file, with the .reg extension. The end user can then "merge" that file into their own registry. I would strongly recommend that the end user backup their registry first, of course.

To "merge" the file, just copy the file to the end user machine, then have the enduser right-click and select "merge".
0
 

Author Comment

by:pcalabria
ID: 36935563
Thanks for your help.

I'm not sure if I have solved this problem yet, but I did realize several things that I did wrong when I read the related KB article provided by MX.

The article states you should use the Save and Publish option of Access 2010 which I did not know about.  I actually used the save option available when in design mode, and I also did not fix a compile error before sending the user a file, which I suspect is the real problem.

I also noticed that they moved the create accde file to the "Save and Publish" option which probably confused me - who took my cheese! :-)

I'm going to split the points and close this question and then open a new question if the problem still exists.  Since you both (MX and LSM) responded with the same solution within minutes of each other, I'm going to award 166 to each of you for the registry solution which I will save for future use, and 167 for the link to the KB article which helped me figure out what I did wrong!
0
 

Author Closing Comment

by:pcalabria
ID: 36935567
I'm going to split the points and close this question and then open a new question if the problem still exists.  Since you both (MX and LSM) responded with the same solution within minutes of each other, I'm going to award 166 to each of you for the registry solution which I will save for future use, and 168 for the link to the KB article which helped me figure out what I did wrong!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month18 days, 11 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question