Front end startup problem

Chalkie42

Registered User.
Local time
Today, 02:35
Joined
Feb 18, 2008
Messages
42
You know that feeling when you are sure there is a really easy answer but you just can't find it? Well here's mine:

I have just delivered my front end to the user. I have incorpoated a splash screen which uses the timer event and then a sign-in form opens. Trouble is, when the user opens the FE it just sits there on the splash screen. The Access security won't let the above process run because it stops all VBA until the user shift-starts and clicks the 'allow' button. After that it all works fine until I deliver an updated version and it all starts again. All using A2010.

Can anyone suggest what I need to do to avoid the user having to shift-start?

Many thanks in anticipation.
 
If the application is put in the same location each time, then setting the location as a secure location on a one-time basis should help.

I assume the user is using a full install of MS Access rather than the Access Runtime.

SHADOW
 
So if the OP delivers the frontend to his end user, and the end user doesn't have office setup in a trusted location then what?

It isn't that his "OFFICE" setup in a trusted location. It is that a Trusted Location has been defined by the user from his Access application. In 2010, if you open a database file and enable code once, it assumes that you are trusting that file. If the file gets replaced or moved, then it no longer is trusted. When replaced, they have to do it again the first time unless they have gone in and defined the location that the file will be as a trusted location. At that point every time the file is replaced it will still be trusted since it is in a trusted location.
 
Thanks guys. I just gotta get round all the machines and set up trusted folders then get the user to save new versions there. Makes sense.

Thanks for your help.
 
Thanks guys. I just gotta get round all the machines and set up trusted folders then get the user to save new versions there. Makes sense.

Thanks for your help.

You can do it quickly by using a reg file.

Save this as a .reg file and then just run it on each pc:

Code:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location0]
"Path"="C:\\YourFolderHere\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="6/17/2013 1:00 PM"

12.0 is Access 2007. If you have 2010 use 14.0 and if you have 2013 use 15.0

And, yes the two backslashes are necessary where they are.
 

Users who are viewing this thread

Back
Top Bottom