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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Runtime 2013 Security Warnings, Access 2013    
 
   
Alexander
post Nov 29 2017, 06:34 AM
Post#21



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


Also opened regedit and checked the new Location (I called it 57) and sure enough .. all present and correct.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
JonSmith
post Nov 29 2017, 01:25 PM
Post#22



Posts: 3,161
Joined: 19-October 10



Fantastic!
Noticing things like the double / and starting to understand all of the little nuances will then make any coding solutions much easier! It might not be possible to completely remove those warnings. We'll have to see!

What language do you want to look at for adding trusted locations programatically?
Go to the top of the page
 
Alexander
post Nov 29 2017, 01:35 PM
Post#23



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


Thanks Jon and I can write modules in Access so can it be VBA?

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
Alexander
post Nov 30 2017, 05:39 AM
Post#24



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


Hello Jon ...

I managed to edit my .reg file and have added that SubFolders are also trusted.

I used "AllowSubfolders"=dword:0000001

I have read that "AllowSubfolders"=dword:0000000 would mean Subfolders are not trusted.

I also see the date and time can be added as an aid to the date/time of update or creation.

I am happy to be guided by you on the next steps but great progress so far and I have it working.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
Alexander
post Dec 3 2017, 05:21 PM
Post#25



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


Back again Jon

I have tried some VBA but will need some help on this one.

I have looked at several examples but do not know how to run the code.

Maybe they are run from within my application to set the trusted location before the application runs?





--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
JonSmith
post Yesterday, 07:21 AM
Post#26



Posts: 3,161
Joined: 19-October 10



Sorry for the long delay and a shame no-one else picked this up in the meantime.

Chip has a webpage that goes into great detail about using VBA and the registry that you could look at?

http://www.cpearson.com/excel/registry.htm
Go to the top of the page
 
Alexander
post Yesterday, 09:10 AM
Post#27



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


Very good of you Jon and all sorted with the .reg file method and the Runtime...thanks for all your help.

Now I will read the link (lots there to get stuck into) and come back if I have questions.

I wanted to find out how to automatically install for a client when I did not know their desktop path and then after installation set the desktop and subfolders to trusted.

Thanks again for the link and I will keep trying.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
Alexander
post Today, 07:09 AM
Post#28



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


Thanks Jon .. the penny has dropped on VBA for the trusted locations.

I now understand there is no need to know the users desktop path as you can allow the user to place it anywhere but I use code to set the trusted location in that selected location.

Thanks again and that link was very useful.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    15th December 2017 - 08:51 AM