Here is the reg file I use to create a trusted location. Note the key is all one line. The Path and Description are lines 2 and 3. I usually use the application name as the location name. Keep it to eight characters max. Change the Office number from 12 to 14 for Access 2010.
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\LocationNameGoesHere]
"Path"="FolderPathGoesHere"
"Description"="DescriptionGoesHere"
Bill Mosca
--- In MS_Access_Professionals@yahoogroups.com, "mike" <akcam2006@...> wrote:
>
> Thanks again. Still looking for some help on the original issue.
>
> Mike
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Mike-
> >
> > Consider putting it in the user's My Documents and write a Trusted Location
> > entry to the Registry:
> >
> > \HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted
> > Locations\LocationN
> >
> > .. where "N" is the "next" available number in the sequence Location0,
> > Location1, etc.
> >
> > You need:
> > AllowSubfolders REG_DWORD 0 or 1 -- use 1 to allow subfolders
> > Date REG_SZ date and time of the install
> > Description REG_SZ a string describing what you've done
> > Path REG_SZ C:\Users\<username>\Documents\
> >
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mike
> > Sent: Tuesday, July 31, 2012 10:06 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Access 2007 ribbon not showing in Access 2010
> >
> > Copy all, this database is used by over 5,000 users where would you recommend we
> > have the .exe file install the files so that they are available to all users?
> >
> > Mike
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@>
> > wrote:
> > >
> > > Hi Mike
> > >
> > >
> > >
> > > You should never install an Access application in Program Files on any
> > > system with Vista or later. The reason is because of a "security feature"
> > > known as "virtualization" which is intended to protect users from themselves
> > > but actually causes more problems than it solves.
> > >
> > >
> > >
> > > What happens is this: If a process which is NOT running "as Administrator"
> > > tries to write to a file under C:\Program Files, the system makes a copy of
> > > that file in a "virtual" folder. This folder is located in a corresponding
> > > subfolder under C:\Users\<username>\AppData\Local\VirtualStore\Program
> > > Files. Any subsequent reference to that file uses the "virtual" copy, not
> > > the "real" one.
> > >
> > >
> > >
> > > Of course, Access always updates a database file and changes its modified
> > > date every time it is opened, so the FIRST time you open your front-end
> > > after installation it gets virtualized, and subsequent uses open the copy.
> > > Now, if you update the front-end with a new copy (installed "as
> > > Administrator" by your setup program) then the "real" copy will be replaced,
> > > but the "virtual" copy (the old version) will continue to be used.
> > >
> > >
> > >
> > > As well as C:\Program Files, Windows virtualizes the C:\Windows folder and
> > > also (astonishingly!) C:\ProgramData. I say astonishingly, because
> > > C:\ProgramData is intended for storing data which is shared by all users.
> > > However, the moment a user writes to a file, the system creates a private
> > > copy and the changes never get seen by other users!
> > >
> > >
> > >
> > > So, in short, avoid putting any updateable files in any of these three
> > > virtualized folder trees.
> > >
> > >
> > >
> > > I don't see how this could be causing your problem, but it may be that the
> > > user is actually opening an old copy and not the one you have installed.
> > > Also, I don't believe that C:\Program Files is *automatically* a trusted
> > > location as far as Office is concerned.
> > >
> > >
> > >
> > > Best wishes :-)
> > >
> > > Graham
> > >
> > >
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mike
> > > Sent: Tuesday, 31 July 2012 09:05
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Re: Access 2007 ribbon not showing in Access 2010
> > >
> > >
> > >
> > >
> > >
> > > Yes, the data files are distributed using a setup .exe file that installs
> > > them in the Program Files directory of the computer. Great question though,
> > > thank you.
> > >
> > > Mike
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca"
> > > <wrmosca@> wrote:
> > > >
> > > > Mike
> > > >
> > > > Do your clients have the database file(s) in a trusted location?
> > > >
> > > > Regards,
> > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > http://www.thatlldoit.com
> > > > Microsoft Office Access MVP
> > > >
> > > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
> > > 1E
> > > > My nothing-to-do-with-Access blog
> > > > http://wrmosca.wordpress.com
> > > >
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "mike" <akcam2006@>
> > > wrote:
> > > > >
> > > > > I have a custom ribbon I built using XML in Access 2007. It seems to
> > > work just fine on my computer with Access 2010 but when most of my clients
> > > open the file on their computer's using Access 2010 the ribbon will not
> > > display. The only help I could find on the internet about this issue warned
> > > me about the case sensitive nature of the ribbon in Access 2010, something
> > > that apparently didn't affect Access 2007. I have checked all my XML and VBA
> > > and everything seems to match up. Any other thoughts as to what could be
> > > causing the issue?
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
Tidak ada komentar:
Posting Komentar