Enable this content on one machine only?

[M Skabialka]

Three people use the same Access 2003 database using Access 2007. It's a
front end/back end database. When they open the database they can
immediately use all of the functions.
I set up a new employee and laptop to use the same database and when it is
opened it says there is a security warning, that some features are disabled.
In fact, no visual basic code will run until they click the warning and
select "Enable this content".
All machines are Windows XP, all have Access 2007 on them. What needs to be
changed on this new machine so that this warning does not appear? The
database is secured on the server as far as allowing certain people to get
to it goes.

Mich

 

[golfinray]

I would start by making sure all the service packs and hotfixes have been
loaded on the new user's machine. Sounds like a fairly common problem.

 

[M Skabialka]

I also develop databases for a very secure office where this warning comes
up for everyone, by design. They have learned to enable the content every
time.
But I've never had it for one person in an office when the environments are
the same and no-one else gets the warning. This new laptop has all of the
latest Windows and Office updates and patches.

 

[M Skabialka]

Finally found it (maybe...):
I had to add a trusted location, but this being on the network, I had to
select "Allow Trusted Locations on my network (not recommended)", found at
the bottom of the screen. But is this for the front end or the back end or
both?? I haven'y tested it on the new machine yet.

 

[Dale Fye]

You should put the front-ends on the users individual machines.

Then you can setup a trusted location on that machine where you will install
all of the Access applications that they should have permissions to run, or
you could do one application per folder.

I prefer to put this in:
C:\Users\FirstName.LastName\AppData\Roaming

which is a hidden system folder.

 

[M Skabialka]

Why would you put a database in a hidden system folder - how do the users
find it?
Most of my users put it on the desktop. So if I set up the trusted location
of the desktop after copying the front end there, if there is a change and
they need the newest front end, is the location still trusted?
In other words - do I have to set up Access to have a trusted location on
each person's machine, or can I do something generic in the master copy of
the front end using "..\Desktop" to cover anyone's desktop?
Mich