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
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Post by 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
--
Message posted via http://www.accessmonster.com

[RedHeadedMonster via AccessMonster.com]

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

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

[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
http://I.Am/DougSteele
(no private e-mails, please)

Post by RedHeadedMonster via AccessMonster.com
I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[unknown]

Post by 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
http://I.Am/DougSteele
(no private e-mails, please)

Post by RedHeadedMonster via AccessMonster.com
I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[unknown]

Post by RedHeadedMonster via AccessMonster.com
I consider myself a decent coder, but dont have a clue how or where to use
that. Any suggestions?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[unknown]

Post by 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
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Post by 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
--
Message posted via http://www.accessmonster.com

[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

Post by 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
--
Message posted via http://www.accessmonster.com

[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?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
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

Post by 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?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[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!

Post by 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

Post by 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

[quoted text clipped - 29 lines]

Post by RedHeadedMonster via AccessMonster.com

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

[unknown]

Post by 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!

Post by 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

Post by 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

[quoted text clipped - 29 lines]

Post by RedHeadedMonster via AccessMonster.com

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[unknown]

Post by 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

Post by 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?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[unknown]

Post by 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?

Post by 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

Post by 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

[quoted text clipped - 32 lines]

Post by RedHeadedMonster via AccessMonster.com
Thanx!
RHM

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200909/1

[unknown]

Post by 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

Post by 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
--
Message posted via http://www.accessmonster.com

[Jaime Picoloto]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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
--
Message posted via http://www.accessmonster.com

[unknown]

Post by 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.

Post by RedHeadedMonster via AccessMonster.com
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?

Post by RedHeadedMonster via AccessMonster.com
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.

Post by RedHeadedMonster via AccessMonster.com
Or....
Could I have the .bat copy the FE to Access 2007's default trusted location,

will it let me do that?

Post by RedHeadedMonster via AccessMonster.com
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.

Post by RedHeadedMonster via AccessMonster.com
Thanx!

RHM
Message posted via http://www.accessmonster.com

[unknown]

Post by 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.

Post by RedHeadedMonster via AccessMonster.com
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?

Post by RedHeadedMonster via AccessMonster.com
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.

Post by RedHeadedMonster via AccessMonster.com
Or....
Could I have the .bat copy the FE to Access 2007's default trusted location,

will it let me do that?

Post by RedHeadedMonster via AccessMonster.com
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.

Post by RedHeadedMonster via AccessMonster.com
Thanx!

RHM
Message posted via http://www.accessmonster.com