Update FE with Windows Script?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SC ChiefsFan - 26 Jun 2005 00:59 GMT

Is it possible to update a Front-End with windows script (vbs)? I've got a
short and simple script setup to check a version and copy the MDE if
necessary, but the following code results in a flash of Microsoft Access,
then it disappears (I assume because the script is finished running).

Set objAccess = CreateObject("Access.Application")
objAccess.Visible = True
set objDb = objAccess.OpenCurrentDatabase & _
("C:\PremierApps\budman\bud_man.mde")

Any comments/suggestions? I tried a BAT but have users that will get
confused by having the command window stay open. I've seen the samples of
updaters from other posts and am hoping to avoid several more hours of
creating and testing an "udpater" database.

Regards,
Doug Miller

Reply to this Message

Tony Toews - 26 Jun 2005 04:34 GMT

>Any comments/suggestions?

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message

Connie - 29 Jun 2005 18:49 GMT

if your bat file is working except for the fact the command window stays
open, you can add the EXIT command which will close the command window..
presuming you're using Windows 2000 or later. If it's an older version of
Windows then in the properties of the batch file you can turn on the option
that closes the window when finished.

HTH
Connie

> Is it possible to update a Front-End with windows script (vbs)? I've got a
> short and simple script setup to check a version and copy the MDE if
[quoted text clipped - 13 lines]
> Regards,
> Doug Miller

Reply to this Message