Access Developer Extentions - Package Wizard - Update runtime systematically

I am using Access 2003 Developer Extensions to package a runtime solution for my database.  I often come up with changes and would like to deploy them without having to go to each PC.  When I have a new version to install, I have to go to the PC... go to the control panel and uninstall the current version... then run through the setup.

Is there a way to set all of this up in a batch file?  So maybe the user could run this and have the application updated all at once - without my needing to go and do this on each PC??
Scotto13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thenelsonCommented:
Take a look at Updated Front End at http://www.thenelson.name/ for how to do this automatically.  It is well documented but you may ask me any questions here.

Nelson
0
Scotto13Author Commented:
Hi Nelson,

This looks like a great solution, but I am not using a front end, rather I have a runtime that needs to be installed on indivuals PCs.  These people do not have MC Access on their PCs.  Can this be addopted to manage this?  
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The PDW should build your Runtime install for you. Nelson's solution would simply update the program you provide for use with the runtime (your .mde/.mdb file).

Are these local users, on the same network? Or remote users?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Scotto13Author Commented:
Local users on the same network.  I don't know what a PDW is.  I use the installer that comes with the Package Wizard.  I think its MSI.  
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That's the Packaging and Deployment Wizard (the PDW). It does produce a Windows MSI package.

Are you packaging the Access Runtime along with your developed application? If so, then you would only deploy the package once; afterwards you'd deploy a Patch or Update and doing that is quite difficult - you'd be better off using a suggestion like Nelson. There are other utilities to do this, or you can use a simple batch file to copy your new frontend across the network.
0
Scotto13Author Commented:
I'm not getting something...  When I make changes to the .mdb, I then package this and it needs to be installed on each PC.  Nelson, how does your tool help with this?  It seems that it would only work if I had the .exe installed on the network instead of each PC.  Is that what you're suggesting I do?

If I use another utility to "copy the frontend accros the network", would this deploy the .exe?  Please break this down for me, as I am new to using PWD.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Generally, the only time you need to "install" would be the very first time the app is installed on a machine. At that time, you'd have to install the Runtime, any ActiveX controls you may be using, any code libraries/dll/ocx files, etc etc ... after that, however, you only deploy the files you need to update (and that would NOT include the Runtime). Generally, you would only need to update the actual "frontend" file, but none of the supporting files.

So a utility to simply copy the new frontend from a server somewhere to the workstation would suffice ... no need to repackage and redeploy, unless you need to distribute a new ActiveX control or code library.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
BTW: here's a link to another free frontend update utility:

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

This has been around for some time and doesn't use the Scripting runtime to copy files ... the scripting runtime is often disabled by corporate IT departments in an effort to reduce spyware and malware, and can be picked up by antivirus and spyware detection program, plus using the scripting runtime would preclude the use of digital signatures, if you need to do this.
0
Scotto13Author Commented:
Thank you both for the excellent ideas.  I will work on making it happen with my app.  
0
thenelsonCommented:
Thanks for the assist.  Good luck on your project.

Nelson
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.