Trusted location

[RedHeadedMonster via AccessMonster.com]

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

 

[Douglas J. Steele]

You might be able to push out a registry update, along the lines of what
Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

 

[Jeff Boyce]

Don't know if this will help ...

I have several different applications in use at my agency. Rather than have
to deal with each separately, I created a single folder under the C:\ root
and have told Access 2007 to trust that folder and any subfolders.

Then when someone needs to work with one of my apps, I add a subfolder for
that app and put the front-end there. As long as you're using the .bat file
to tell it where to load, why not load somewhere you've already trusted?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[RedHeadedMonster via AccessMonster.com]

I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

You might be able to push out a registry update, along the lines of what
Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

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

[quoted text clipped - 32 lines]

Thanx!
RHM

 

[RedHeadedMonster via AccessMonster.com]

Thats along the lines I was thinking. I've already tested the creation of
folder on the C:\ to place the FE. Worked fine. But is there a way to make
sure that at least the first time a user does this that this folder will be
"trusted'? Or am I stuck with having to go to each individual's pc to set
this location as a trusted one?

Don't know if this will help ...

I have several different applications in use at my agency. Rather than have
to deal with each separately, I created a single folder under the C:\ root
and have told Access 2007 to trust that folder and any subfolders.

Then when someone needs to work with one of my apps, I add a subfolder for
that app and put the front-end there. As long as you're using the .bat file
to tell it where to load, why not load somewhere you've already trusted?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

[quoted text clipped - 32 lines]

Thanx!
RHM

 

[Jeff Boyce]

Perhaps it's a matter of scale (and customer service). In my situation,
there are fewer than 50 folks, so visiting each user/PC and ensuring that it
is set up correctly seems to have reduced the number/frequency of "HELP!"
calls.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thats along the lines I was thinking. I've already tested the creation of
folder on the C:\ to place the FE. Worked fine. But is there a way to
make
sure that at least the first time a user does this that this folder will
be
"trusted'? Or am I stuck with having to go to each individual's pc to set
this location as a trusted one?

Don't know if this will help ...

I have several different applications in use at my agency. Rather than
have
to deal with each separately, I created a single folder under the C:\ root
and have told Access 2007 to trust that folder and any subfolders.

Then when someone needs to work with one of my apps, I add a subfolder for
that app and put the front-end there. As long as you're using the .bat
file
to tell it where to load, why not load somewhere you've already trusted?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

[quoted text clipped - 32 lines]

Thanx!
RHM

 

[RedHeadedMonster via AccessMonster.com]

Yes I suppose you are right. With mine its more 100+ in 3 different
buildings *sigh*
Thanx for your help! Have a nice Day!

Perhaps it's a matter of scale (and customer service). In my situation,
there are fewer than 50 folks, so visiting each user/PC and ensuring that it
is set up correctly seems to have reduced the number/frequency of "HELP!"
calls.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thats along the lines I was thinking. I've already tested the creation of
folder on the C:\ to place the FE. Worked fine. But is there a way to

[quoted text clipped - 29 lines]

 

[Douglas J. Steele]

That actually isn't code. He's showing a key that needs to be set in the
registry.

One approach is to set it manually, open RegEdit, find the key, export it to
a .REG file and then have the users double-click on it to update their
registries.

Another approach, of course, is to use code to insert it into the registry
for each person. Note that this doesn't necessarily have to be VBA code in
an Access application (especially since the code won't run unless they
enable it...): it could be VBScript or even a .BAT file running Reg Add.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

You might be able to push out a registry update, along the lines of what
Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

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

[quoted text clipped - 32 lines]

Thanx!
RHM

 

[Jaime Picoloto]

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

 

[o;;]

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

 

[o;;]

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

 

[o;;]

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

 

[o;;]

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.
their trusted location so that the FE will open without delay and without
all
the security stuff?
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.
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.
RHM

 

[o;;]

You might be able to push out a registry update, along the lines of what
Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

 

[o;;]

I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

You might be able to push out a registry update, along the lines of what
Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

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

[quoted text clipped - 32 lines]

Thanx!
RHM

 

[o;;]

That actually isn't code. He's showing a key that needs to be set in the
registry.

One approach is to set it manually, open RegEdit, find the key, export it
to a .REG file and then have the users double-click on it to update their
registries.

Another approach, of course, is to use code to insert it into the registry
for each person. Note that this doesn't necessarily have to be VBA code in
an Access application (especially since the code won't run unless they
enable it...): it could be VBScript or even a .BAT file running Reg Add.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

You might be able to push out a registry update, along the lines of what
Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

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
[quoted text clipped - 32 lines]
Thanx!
RHM

 

[o;;]

Don't know if this will help ...

I have several different applications in use at my agency. Rather than
have to deal with each separately, I created a single folder under the C:\
root and have told Access 2007 to trust that folder and any subfolders.

Then when someone needs to work with one of my apps, I add a subfolder for
that app and put the front-end there. As long as you're using the .bat
file to tell it where to load, why not load somewhere you've already
trusted?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[o;;]

Thats along the lines I was thinking. I've already tested the creation of
folder on the C:\ to place the FE. Worked fine. But is there a way to
make
sure that at least the first time a user does this that this folder will
be
"trusted'? Or am I stuck with having to go to each individual's pc to set
this location as a trusted one?

Don't know if this will help ...

I have several different applications in use at my agency. Rather than
have
to deal with each separately, I created a single folder under the C:\ root
and have told Access 2007 to trust that folder and any subfolders.

Then when someone needs to work with one of my apps, I add a subfolder for
that app and put the front-end there. As long as you're using the .bat
file
to tell it where to load, why not load somewhere you've already trusted?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

[quoted text clipped - 32 lines]

Thanx!
RHM

 

[o;;]

Perhaps it's a matter of scale (and customer service). In my situation,
there are fewer than 50 folks, so visiting each user/PC and ensuring that
it is set up correctly seems to have reduced the number/frequency of
"HELP!" calls.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thats along the lines I was thinking. I've already tested the creation
of
folder on the C:\ to place the FE. Worked fine. But is there a way to
make
sure that at least the first time a user does this that this folder will
be
"trusted'? Or am I stuck with having to go to each individual's pc to
set
this location as a trusted one?

Don't know if this will help ...

I have several different applications in use at my agency. Rather than
have
to deal with each separately, I created a single folder under the C:\
root
and have told Access 2007 to trust that folder and any subfolders.

Then when someone needs to work with one of my apps, I add a subfolder
for
that app and put the front-end there. As long as you're using the .bat
file
to tell it where to load, why not load somewhere you've already trusted?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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
[quoted text clipped - 32 lines]
Thanx!
RHM

 

[o;;]

Yes I suppose you are right. With mine its more 100+ in 3 different
buildings *sigh*
Thanx for your help! Have a nice Day!

Perhaps it's a matter of scale (and customer service). In my situation,
there are fewer than 50 folks, so visiting each user/PC and ensuring that
it
is set up correctly seems to have reduced the number/frequency of "HELP!"
calls.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thats along the lines I was thinking. I've already tested the creation
of
folder on the C:\ to place the FE. Worked fine. But is there a way to

[quoted text clipped - 29 lines]

Thanx!
RHM