Access Runtime Trusted Location Issue

We do a large amount of scripted/vba/macro interaction via access to our accounting software.  

Unfortunately one of our employees just upgraded to 2010, and instead of a full version she was given access 2010 runtime.  

It pops up and the only ribbon other then a tiny file list, is a pdf ribbon.  

Any idea how to fix it so we can get this to run properly for her?  

Will runtime be able to do what we were using access full version for in the past?

Thanks!
LVL 12
ScriptAddictAsked:
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.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
In an Access RunTime version, the built in default Ribbons (Menus prior to A2007) are not available.  You must supply custom ribbons (in A2010) and app Navigation (if required).

Question:  Is this an MDB running in A2010, or did you convert to ACCDB?

mx
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Adding to the previous reply, the Access runtime is design for databases that have a custom bui8lt navigation and do not depend on the built in Ribbons or menus. Having your database in a trusted location or setting the macro security level to low will not get the built in Ribbons or menus back.

See my article for more information found here: Trust Center in Access 2007 and 2010 Trusted Locations
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
But a TL is required to run most any VBA code and/or execute most functions.

BTW ... you can emulate the RunTime environment in your development environment by starting your db using the Command Line and specifying the /Runtime option:

Emulate a RunTime version:
"C:\Program Files\Microsoft Office\Office14\msaccess.exe" "\SomeFolder\SomeDatabase.mdb" /runtime

This way, you can see what is missing and what you have to provide.

And to create custom Ribbons ... you need this (best on the net):

http://www.accessribbon.de/en/
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
TIP:

You can also rename the .mdb or ,.mde to a .accdr to get Access 2007 or 2010 to open it in runtime mode.

From: What is the Access Runtime Version?
ScriptAddictAuthor Commented:
Thanks for all this great information.  

I guessed it was something like that, but didn't have anyone that could provide this kind of detailed information.  

One last question.  While the normal ribbons won't appear, All they really need to do is kick off a macro.  Will the side list appear that shows all the database objects?  (tables, queries, reports, forms etc?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
That depends on your settings in Options>>Current Database ... it's up to you.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
However, in RunTime ... you cannot make any design changes.

Are you not going to provide an app navigation ?

mx
ScriptAddictAuthor Commented:
I've never bothered with app navagation before, it was just a database that 2 or three people use and I just had a macro that they clicked to do what they needed to do.  

It does quite a lot and I suppose I could do a considerable amount of polishing on it, but it's constantly developing as it is the main interface between our web application for time and employee training, and our accounting system.

What I'd really like to do (end goal) is to get that lady able to use access runtime to kick off her macro.

Currently it's popping up with a trusted document warning, and I have no ribbons or sidebars.

It also doesn't show the different object types.  It doesn't really appear to be opening.

I've tried editing her registry to add it as a trusted location but with no luck.  I tried a small utility to do the same thing again no luck.

I've then turned to EE to see if someone could help me overcome the issue and find it if it's even possible to use Access runtime to do what I would like to do.

-SA
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, Trusted Locations / Documents can be added right from the A2010 UI ... although that requires Access on that system of course.  And yes, you can manually add them to the Registry or with a utility (I did that here at work).

Soooo ... what is the status right now ?

mx
ScriptAddictAuthor Commented:
Not currently working.  When I try and open up the database I get a trusted document warning.  I click ok and then nothing happens.

My understanding of how it is supposed to work is that I click ok and it adds the trusted document/location.  

Perhaps I need a service pack for the runtime enviroment?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
So ... the system with the issues does not have Office or does not have Access ?
Not specifically aware of a SP for Runtime ...

mx
ScriptAddictAuthor Commented:
It has office 2010, but access is 2010 runtime.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
So ... did you say you have tried to manually create TLs / TDs on that system ... and you still get the error ?

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Because there is also this setting - see image

1
ScriptAddictAuthor Commented:
Good point.  I'll see if I can figure out what the registry key entry for that would be.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
try:


2007
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001

Open in new window


2010
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security]
"VBAWarnings"=dword:00000001

Open in new window



for trusted locstions:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location0]
"Path"="C:\Users\UserName\myfolder"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="9/2/2010 6:10 PM"

Open in new window

ScriptAddictAuthor Commented:
Is the date entry really required?  I had skipped that when I manually edited the registry.

I've applied the macro security change to the workstation, and I'll see what happens tomorrow after she reboots the machine.  

Thanks everyone for your support so far.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I don't know ... maybe Tech does ...?
Maybe for TD's ... but not for TL's
mx
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I have never tested it without the date. Since it works with the date I  always added it.
clarkscottCommented:
Access 2010 uses INTERNET EXPLORER'S Trusted Sites.
(I had this same issue and it drove me nuts...)

1.  Open Internet Explorer
2. Click TOOLS.
3. Click INTERNET OPTIONS
4. Click SECURITY tab
5. Click the TRUSTED SITES icon (green checkbox).
6. Click the SITES button in the TRUSTED SITES section.
7. Add the location of your files.

Note the "security level' sections.  These values can be edited.

Scott C
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
@Scott, that is true with all versions of Access when opening files in an intranet location (share or mapped drive).  That is actually a IE security setting that gets installed with IE version 7 (or maybe 6) or later.  This is in addition to the Trusted Locations in Access 2007/210.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Trusted sites ... not the same as Trusted Locations ... right ?
clarkscottCommented:
Not sure.. .but it solved my problem.
Scott C
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I'm pretty sure not ...
ScriptAddictAuthor Commented:
Just heard back on this, now it is opening,  but she doesn't see anything.  

We no longer get error messages during opening, and I see access create a file lock.  But nothing else appears.  

So then the next best step is to create a custom toolbar that will allow her to trigger her macro?
clarkscottCommented:
In the Trusted Sites - you can enter a folder path (not a site address) ?
Scott C
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
If nothing is displayed then there is no  start up for defined.

I recommend just creati8ng a form with commands button. Set the for as the

See this MSDN article: Basics for Building Access 2007 Runtime-Based Solutions

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
ScriptAddictAuthor Commented:
Just wanted to say thanks for sticking with me on this guys.  This was my first adventure into Access runtime, and because of your help, likely not my last.  <br /><br />issues were:<br />trusted location<br />macro security<br />Missing navagation<br />Some coding that didn't work in runtime that works normally<br /><br />But all was corrected and is now working for my end user.  In a far more user friendly way!<br /><br />Thanks again!<br /><br />-SA
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.