I have several SPLIT databases. Currently I have a SHORTCUT for each
database that a user runs. It is a .bat that copies the FE from the
server to
the C:\ drive of the users computer and then opens the database. I did
it
this way so that I wouldnt have to constantly send out new FEs to all the
users.
My question is....Do I really have to go to each individual users PC and
set
their trusted location so that the FE will open without delay and without
all
the security stuff?
Between the 8 databases being used, Im talking 100+ users....is there not
a
way to do this programmatically? I mean, sure I could send out
instructions
on how to set up a trusted location, but most or them will either not do
it
or not do it correctly so Im back to individually setting it for each pc.
Or....
Could I have the .bat copy the FE to Access 2007's default trusted
location,
will it let me do that?
Im still running A2003, but Office 2007 will be installed on 9/11 whether
we
want it or not so Im trying to figure out what Im gonna do. Been reading
everything & anything I can get my hands on for this conversion and cant
seem
to find a better answer than individually install.
Thanx!
RHM
