UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Runtime 2013 Security Warnings, Access 2013    
 
   
Alexander
post Nov 14 2017, 04:36 AM
Post#1



Posts: 3,351
Joined: 30-December 03
From: Glasgow, Scotland


My client does not have the full 2013 Access version but installed the Runtime version.

He has Office 2013 installed (Word and Excel) but not the full Access version.

My question ... he has security warning when opening the application .... as he has Office installed can he set up a trusted location (say the Desktop) using Word and then place the application on the Desktop and open with no security warnings.

Maybe there is an easy way to disable these security warnings in Runtime 2013?

Any help appreciated.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
cheekybuddha
post Nov 14 2017, 06:20 AM
Post#2


UtterAccess VIP
Posts: 9,269
Joined: 6-December 03
From: Telegraph Hill


See if the code in this thread can help you.

No idea if it will work from the runtime. And I guess the user must have permissions to update the registry.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
Alexander
post Nov 14 2017, 06:26 AM
Post#3



Posts: 3,351
Joined: 30-December 03
From: Glasgow, Scotland


Many thanks cheekybuddha

Yes it does sound rather complex for what should be a simple process.

Will check if user has the authority and then consider the options but suspect easier to purchase full and legal copy of Access to eliminate any issues.

Appreciate the links.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
cheekybuddha
post Nov 14 2017, 06:27 AM
Post#4


UtterAccess VIP
Posts: 9,269
Joined: 6-December 03
From: Telegraph Hill


A full copy of Access still requires you to set Trusted Locations to avoid security prompts

--------------------


Regards,

David Marten
Go to the top of the page
 
Alexander
post Nov 14 2017, 06:41 AM
Post#5



Posts: 3,351
Joined: 30-December 03
From: Glasgow, Scotland


Yes David but that is a simple job the user can do with a few mouse clicks and just a matter of following a few lines of instruction.

Going into the registry is not for the faint of heart !!!!!!!!

Thanks for the help

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
JonSmith
post Nov 14 2017, 06:49 AM
Post#6



Posts: 3,145
Joined: 19-October 10



The registry is actually super easy and I can confirm it is the correct way to resolve this.
The user will also have access to the registry as its in the Current User tree.

An alternative to this is to ask your network admins to sort out the Trusted policy locations which can be set at AD level and work exactly the same for Full Access and Runtime.

JS
Go to the top of the page
 
Alexander
post Nov 14 2017, 07:01 AM
Post#7



Posts: 3,351
Joined: 30-December 03
From: Glasgow, Scotland


Many thanks Jon

Maybe I misread this situation based on your comments.

Is there a simple step by step for this procedure.

Thanks

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
JonSmith
post Nov 14 2017, 07:26 AM
Post#8



Posts: 3,145
Joined: 19-October 10



Yes, its easy.
Check out the registry location
CODE
HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Access\Security\Trusted Locations\Location0
on your machine. That will be your first trusted location in MSAccess. You just need to create another one that instead of Location0 is Location1 or any other free number available and amend the keys to your desired location. Most importantly the Path key.

You can even export these to a reg file that you can install with a simple double click.

Group Policy is still the better option however.

Also please note the 15.0 in the registry location is an indication of Office version. 2013 is 15.0, 2010 is 14.0 etc. It has to be amended for your relevant Office version.

JS
Go to the top of the page
 
Alexander
post Nov 14 2017, 07:33 AM
Post#9



Posts: 3,351
Joined: 30-December 03
From: Glasgow, Scotland


Many thanks Jon ... will have a go and report back.


--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd November 2017 - 11:20 AM