By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

Updated Front-End - Rollout procedure

P: n/a
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
Jul 18 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
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
Jul 18 '06 #2

P: n/a
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
'---------------
Jul 19 '06 #3

P: n/a
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

Jul 19 '06 #4

P: n/a

"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
Jul 19 '06 #5

P: n/a
"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
Jul 19 '06 #6

P: n/a
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
'---------------
Jul 20 '06 #7

P: n/a
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

Jul 20 '06 #8

P: n/a
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


Jul 20 '06 #9

P: n/a
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
Jul 20 '06 #10

P: n/a
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

Jul 21 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.