Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-14-2019, 08:47 AM   #1
KACJR
Newly Registered User
 
Join Date: Jul 2012
Posts: 47
Thanks: 27
Thanked 1 Time in 1 Post
KACJR is on a distinguished road
A Question of Trust

Greetings to the well of knowledge...

All of my Access DBs are front-ends that talk to our central SQL Server. I manage the development and release new versions on a fairly frequent basis. I install the "gold" copy of the Access DB on a network share and instruct my users to take a copy of the DB and paste it to their desktops. They are instructed to NOT run the copy on the network share.

All of my end users run Access 2016 runtime.

Now under Windows 7, users would get a warning about the DB not being a trusted document. I just instruct them to enable content and go on their way.

Under Windows 10, users do not get this warning so are not able to enable content and continue. Instead, the DB just closes with no errors.

So it sounds as though I need do something trust-related.

My question, then, is: if I establish a trust with the copy of the DB that resides in the network share and an end user takes a copy of the DB to their desktop, does the trust follow to the copy?

I hope I explained that well enough.

Thanks,
Ken

KACJR is offline   Reply With Quote
Old 11-14-2019, 08:54 AM   #2
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,586
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A Question of Trust

Hi Ken. Unless it has changed, I thought network locations can't be set as trusted location (or maybe there's a workaround for it). However, if you deploy compiled versions of your database, all the user has to do is confirm that they want to open/run the application when they get the warning. In other words, instead of giving them ACCDBs, save your database as ACCDE and then put that compiled version on the network share for them to copy to their Desktop.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 08:59 AM   #3
KACJR
Newly Registered User
 
Join Date: Jul 2012
Posts: 47
Thanks: 27
Thanked 1 Time in 1 Post
KACJR is on a distinguished road
Re: A Question of Trust

That makes sense but when running under Win10 and using Access 2016 runtime, the warning doesn't come up. Access Runtime just starts then closes with no warnings or errors.


Interestingly, on Win7 PCs running Access 2016 runtime, the warning DOES appear.

KACJR is offline   Reply With Quote
Old 11-14-2019, 08:59 AM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,390
Thanks: 13
Thanked 4,124 Times in 4,056 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: A Question of Trust

Quote:
Originally Posted by theDBguy View Post
Unless it has changed, I thought network locations can't be set as trusted location
There's a checkbox to allow network locations, not checked by default. As far as I know it's always been there.

Win 10 users should still get the warning, at least mine do (they only have the runtime).
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 09:01 AM   #5
KACJR
Newly Registered User
 
Join Date: Jul 2012
Posts: 47
Thanks: 27
Thanked 1 Time in 1 Post
KACJR is on a distinguished road
Re: A Question of Trust

Quote:
Originally Posted by pbaldy View Post
There's a checkbox to allow network locations, not checked by default. As far as I know it's always been there.

Win 10 users should still get the warning, at least mine do (they only have the runtime).

As I noted, I don't allow users to run the copy on the network shared. I require them to take a copy to their desktops.
KACJR is offline   Reply With Quote
Old 11-14-2019, 09:01 AM   #6
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,586
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A Question of Trust

Thanks, Paul. Also, I agree, the warning should still come up for ACCDEs and ACCDRs..
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 09:09 AM   #7
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,390
Thanks: 13
Thanked 4,124 Times in 4,056 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: A Question of Trust

Quote:
Originally Posted by KACJR View Post
As I noted, I don't allow users to run the copy on the network shared. I require them to take a copy to their desktops.
Yes I know, my comment was in response to DBG's thought that network locations weren't allowed to be trusted. I wrote a version control utility that copies the master file to the user's computer to a specific folder. My users all get a warning when they open the db that they can click on to trust the app. If I put my hands on their computer I can add a registry entry that adds the local folder to their trusted locations, which I don't think can be done from within the runtime version.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 09:11 AM   #8
KACJR
Newly Registered User
 
Join Date: Jul 2012
Posts: 47
Thanks: 27
Thanked 1 Time in 1 Post
KACJR is on a distinguished road
Re: A Question of Trust

So I changed the trust center settings to accept VBA and Active X. This now makes the DB start properly. Is this applied at the DB level so that anyone who copies the DB will get the same settings?
KACJR is offline   Reply With Quote
Old 11-14-2019, 09:16 AM   #9
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,390
Thanks: 13
Thanked 4,124 Times in 4,056 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: A Question of Trust

Unless I'm misunderstanding where you're doing this, I believe Trust Center settings are computer/user specific, not app specific. They would have to duplicate the settings on their computers.

I still don't understand them not getting the warning message though.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 09:22 AM   #10
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,586
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A Question of Trust

Quote:
Originally Posted by KACJR View Post
So I changed the trust center settings to accept VBA and Active X. This now makes the DB start properly. Is this applied at the DB level so that anyone who copies the DB will get the same settings?
Hi. As you can see from this article, the trusted location settings is even "user specific." Maybe you could try downloading the little utility offered there to see if it helps.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 09:41 AM   #11
KACJR
Newly Registered User
 
Join Date: Jul 2012
Posts: 47
Thanks: 27
Thanked 1 Time in 1 Post
KACJR is on a distinguished road
Re: A Question of Trust

Quote:
Originally Posted by pbaldy View Post
Unless I'm misunderstanding where you're doing this, I believe Trust Center settings are computer/user specific, not app specific. They would have to duplicate the settings on their computers.

I still don't understand them not getting the warning message though.

Most of my databases do a lot of initialization during Form_Load. I wonder if this is where the trust error is happening.
KACJR is offline   Reply With Quote
Old 11-14-2019, 10:00 AM   #12
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,586
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A Question of Trust

Quote:
Originally Posted by KACJR View Post
Most of my databases do a lot of initialization during Form_Load. I wonder if this is where the trust error is happening.
Well, before Form_Load can happen, the database content must be enabled first.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 10:10 AM   #13
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,390
Thanks: 13
Thanked 4,124 Times in 4,056 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: A Question of Trust

I've seen a macro test that lets you know whether or not the app is trusted. You can throw up a message box if it's not, to tell the user to trust the app. They do an If/Then test on

[CurrentProject].[IsTrusted]
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 10:12 AM   #14
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,322
Thanks: 115
Thanked 3,099 Times in 2,817 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: A Question of Trust

When an app is trusted, it adds an entry to the registry. Its possible to do this using a script but you can't do this from your Access app as no code will run until its trusted! Chicken and egg situation.

I get round that as follows.
When I distribute apps, I use a professional installer and run the registry script to set a trusted location as part of the installation. This means the app location is already trusted when the app is first run.
Is that a possibility for your situation?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)

Last edited by isladogs; 11-14-2019 at 10:20 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
KACJR (11-14-2019)
Old 11-14-2019, 10:13 AM   #15
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,586
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: A Question of Trust

Quote:
Originally Posted by pbaldy View Post
I've seen a macro test that lets you know whether or not the app is trusted. You can throw up a message box if it's not, to tell the user to trust the app. They do an If/Then test on

[CurrentProject].[IsTrusted]
Hi Paul. Good idea. But if the user is on Runtime, they won't be able to trust the document because the database will just quit after the user confirms the MsgBox. So, maybe add some macro code to "auto-trust" the db? Just a thought...

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by theDBguy; 11-14-2019 at 10:22 AM.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
KACJR (11-14-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows 7 Trust Centre? Lateral General 8 11-13-2013 02:47 PM
Trust Centre aussie General 5 06-19-2012 06:03 AM
Question Trust what location? AccessProgram General 1 12-18-2009 08:45 PM
Trust issue alorenzini Macros 14 10-24-2007 07:07 PM
Runtime Trust Jim Stanicki General 0 09-14-2007 06:45 AM




All times are GMT -8. The time now is 02:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World