Trusted Locations

[ngan]

I know I can set the trusted locations to add network folders, but my
functions still do not run unless I manually check to "allow trusted
locations on my network" checkbox. I would have to do that for every user
that opens a database.

Is there a way to check that in the msp file? I'm upgrading to Office 2007
and I want to make sure that checkbox is checked and the two network folders
are added as trusted locations during the installation.

 

[Arvin Meyer [MVP]]

Yes. You should have a split database with the front-end (forms, reports,
queries, and code) sitting in a Trusted Location on each user's workstation,
and linked to another database on your server. The server does not need to
have a Trusted Location because your IT folks should have it well protected,
and no code will be running on it for your application. For more info on how
and why to split your database, see:

Splitting the database:
http://www.granite.ab.ca/access/splitapp/overview.htm