Updated Front-End - Rollout procedure

[Paul H]

I am sure this has come up before, I have googled the newsgroups but can't
find any info...

I have amended my front-end and need to roll it out. I do not want to visit
every PC on the LAN and copy the files by hand. So what is the best way to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I don't
particularly need the code, just tips on how you folks do it?

Thanks,

Paul

[Jeremy Wallace]

http://tinyurl.com/rkf8v
(http://groups.google.com/group/comp....265533ffad84e0
for posterity's sake)

Paul H wrote:

I am sure this has come up before, I have googled the newsgroups but can't
find any info...

I have amended my front-end and need to roll it out. I do not want to visit
every PC on the LAN and copy the files by hand. So what is the best way to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I don't
particularly need the code, just tips on how you folks do it?

Thanks,

Paul

[John Mishefske]

Paul H wrote:

I am sure this has come up before, I have googled the newsgroups but can't
find any info...

I have amended my front-end and need to roll it out. I do not want to visit
every PC on the LAN and copy the files by hand. So what is the best way to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I don't
particularly need the code, just tips on how you folks do it?

http://www.granite.ab.ca/access/autofe.htm

--
'---------------
'John Mishefske
'---------------

[Larry Linson]

I suspect Tony's Auto FE Updater (already suggested) is more "automated"
than a method I have used, but, FWIW, you'll find an article on "versioning"
at http://accdevel.tripod.com/versioning.htm.

Larry Linson
Microsoft Access MVP

"Paul H" <no****@nospam.comwrote in message
news:5Y********************@eclipse.net.uk...

>I am sure this has come up before, I have googled the newsgroups but can't
find any info...

I have amended my front-end and need to roll it out. I do not want to
visit every PC on the LAN and copy the files by hand. So what is the best
way to automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't particularly need the code, just tips on how you folks do it?

Thanks,

Paul

[Paul H]

"John Mishefske" <jm**********@SPAMyahoo.comwrote in message
news:Qu*****************@tornado.rdc-kc.rr.com...

Paul H wrote:

>I am sure this has come up before, I have googled the newsgroups but
can't find any info...

I have amended my front-end and need to roll it out. I do not want to
visit every PC on the LAN and copy the files by hand. So what is the best
way to automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't particularly need the code, just tips on how you folks do it?

http://www.granite.ab.ca/access/autofe.htm

--
'---------------
'John Mishefske
'---------------

I am probably being stunningly thick, but where is the download link?

Paul

[Keith Wilby]

"Paul H" <no****@nospam.comwrote in message
news:5Y********************@eclipse.net.uk...

>I am sure this has come up before, I have googled the newsgroups but can't
find any info...

I have amended my front-end and need to roll it out. I do not want to
visit every PC on the LAN and copy the files by hand. So what is the best
way to automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't particularly need the code, just tips on how you folks do it?

Thanks,

Paul

I store a copy of my latest FEs in a public folder. Each user's shortcut,
instead of mapping to the mdb, maps to a batch file which copies the FE to
their HDD and opens it. This way, all users always start with the latest
FE. Typically, that batch file would contain this code:

ECHO OFF
DEL "%userprofile%\LocalDBFolder\*.*" /Q
XCOPY "X:\MyFile.mdb" "%userprofile%\LocalDBFolder" /I
START "MyApp" /MAX "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"%userprofile%\LocalDBFolder\MyFile.mdb" /wrkgrp "X:\MyPath\MyWIF.mdw"
/user guest

HTH - Keith.
www.keithwilby.com

[John Mishefske]

Paul H wrote:

"John Mishefske" <jm**********@SPAMyahoo.comwrote in message
news:Qu*****************@tornado.rdc-kc.rr.com...

>>Paul H wrote:

>>>I am sure this has come up before, I have googled the newsgroups but
can't find any info...

I have amended my front-end and need to roll it out. I do not want to
visit every PC on the LAN and copy the files by hand. So what is the best
way to automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't particularly need the code, just tips on how you folks do it?

http://www.granite.ab.ca/access/autofe.htm

--
'---------------
'John Mishefske
'---------------

I am probably being stunningly thick, but where is the download link?

Easy to miss - "Licenses and Download" link mid-page.

--
'---------------
'John Mishefske
'---------------

[Paul H]

Jeremy,

Great website, bloody useful stuff. I have used your Deployment method and
made one amendment thanks to Keith Wilby's post in this thread.

Your notes state:
"The reason to start the database with a shortcut instead of calling the
database (and Access and the MDW) in the batch file, is that this allows the
code window to close as soon as the batch file is done running, instead of
keeping it open until your user closes the database."

This is fixed by prefixing the call with: START "" (Start and two
quotations)

Now the user checks for updates each time the DB is launched and launches
the DB all from the same shortcut.

Many thanks to all.

Paul

"Jeremy Wallace" <je************@gmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

http://tinyurl.com/rkf8v
(http://groups.google.com/group/comp....265533ffad84e0
for posterity's sake)

Paul H wrote:

>I am sure this has come up before, I have googled the newsgroups but
can't
find any info...

I have amended my front-end and need to roll it out. I do not want to
visit
every PC on the LAN and copy the files by hand. So what is the best way
to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't
particularly need the code, just tips on how you folks do it?

Thanks,

Paul

[Paul H]

Jeremy,

Great website, bloody useful stuff. I have used your Deployment method and
made one amendment thanks to Keith Wilby's post in this thread.

Your notes state:
"The reason to start the database with a shortcut instead of calling the
database (and Access and the MDW) in the batch file, is that this allows the
code window to close as soon as the batch file is done running, instead of
keeping it open until your user closes the database."

This is fixed by prefixing the call with: START "" (Start and two
quotations)

Now the user checks for updates each time the DB is launched and launches
the DB all from the same shortcut.

Many thanks to all.

Paul

"Jeremy Wallace" <je************@gmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

http://tinyurl.com/rkf8v
(http://groups.google.com/group/comp....265533ffad84e0
for posterity's sake)

Paul H wrote:

>I am sure this has come up before, I have googled the newsgroups but
can't
find any info...

I have amended my front-end and need to roll it out. I do not want to
visit
every PC on the LAN and copy the files by hand. So what is the best way
to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't
particularly need the code, just tips on how you folks do it?

Thanks,

Paul

[Jeremy Wallace]

Paul,

I'm glad you found it so helpful. I'll definitely change the batch
files I'm using to use that new trick. Thanks so much (and, of course,
to Keith).

Jeremy
Fund for the City of New York
http://metrix daht fcny daht org

Paul H wrote:

Jeremy,

Great website, bloody useful stuff. I have used your Deployment method and
made one amendment thanks to Keith Wilby's post in this thread.

Your notes state:
"The reason to start the database with a shortcut instead of calling the
database (and Access and the MDW) in the batch file, is that this allows the
code window to close as soon as the batch file is done running, instead of
keeping it open until your user closes the database."

This is fixed by prefixing the call with: START "" (Start and two
quotations)

Now the user checks for updates each time the DB is launched and launches
the DB all from the same shortcut.

Many thanks to all.

Paul

"Jeremy Wallace" <je************@gmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

http://tinyurl.com/rkf8v
(http://groups.google.com/group/comp....265533ffad84e0
for posterity's sake)

Paul H wrote:

I am sure this has come up before, I have googled the newsgroups but
can't
find any info...

I have amended my front-end and need to roll it out. I do not want to
visit
every PC on the LAN and copy the files by hand. So what is the best way
to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't
particularly need the code, just tips on how you folks do it?

Thanks,

Paul

[Paul H]

Just a quickie..

You can append the text " /USER %1 " (no quotes) to the DB path in batch
file and add the USER parameter to the shortcut thus..

P:\DBFolder\Update\DBUpdate.bat "Fred Bloggs"

Paul
"Jeremy Wallace" <je************@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...

Paul,

I'm glad you found it so helpful. I'll definitely change the batch
files I'm using to use that new trick. Thanks so much (and, of course,
to Keith).

Jeremy
Fund for the City of New York
http://metrix daht fcny daht org

Paul H wrote:

>Jeremy,

Great website, bloody useful stuff. I have used your Deployment method
and
made one amendment thanks to Keith Wilby's post in this thread.

Your notes state:
"The reason to start the database with a shortcut instead of calling the
database (and Access and the MDW) in the batch file, is that this allows
the
code window to close as soon as the batch file is done running, instead
of
keeping it open until your user closes the database."

This is fixed by prefixing the call with: START "" (Start and two
quotations)

Now the user checks for updates each time the DB is launched and launches
the DB all from the same shortcut.

Many thanks to all.

Paul

"Jeremy Wallace" <je************@gmail.comwrote in message
news:11**********************@75g2000cwc.googlegr oups.com...

http://tinyurl.com/rkf8v
(http://groups.google.com/group/comp....265533ffad84e0
for posterity's sake)

Paul H wrote:
I am sure this has come up before, I have googled the newsgroups but
can't
find any info...

I have amended my front-end and need to roll it out. I do not want to
visit
every PC on the LAN and copy the files by hand. So what is the best
way
to
automate this?

Login script? VBA? Put a CD through the letterbox and run?

Can you give me some pointers on how to configure the best solution? I
don't
particularly need the code, just tips on how you folks do it?

Thanks,

Paul