Update Program

Posted on 2012-09-13
Last Modified: 2012-09-15
I have done some searching around for this, and cant find what I am looking for!  I am trying to make a command button that will automatically update the program with the newest version on a server.  For example, if I realease a version that has fixes, it will connect to my server at the house and download the software and install it.  I am sure I am going to have to package the mde.  I am looking for any suggestions on this!  
Thanks in advance!
Question by:russell12
    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    Tony's Auto FE Updater is pretty much the de-facto standard:

    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    Many commercial installation utilities have this feature, but most don't really work well with Access.

    As mx said, Tony Toews FE Updater could probably do this.

    Or you could build a webservice that you could connect to from your FE, which could provide you with the newest version. You could then use some sort of an external program to download the new release, replace the existing one, and re-launch the new FE.
    LVL 44

    Accepted Solution

    I created a Kixtart script (could be any script) that compares the name of a text file in the FE directory with the associated filename on the server.  If different, it does a file copy for both the database and the text file, deleting the existing text file.  Then the FE database is opened.

    I have version information in a table in the FE database.  The code inside the database also checks the version against the text filename in the FE directory.  If different, the user is notified and the database closed.  This catches the possibility that the FE database was opened directly, rather than through my launch script.
    LVL 2

    Author Closing Comment

    All three answers were very helpful.  I have created a "Start Up" Program out of vb for another program used and if checks registry files for access to overcome the macro warnings.  I think I will write another vb "Start Up" Program for this and compare versions!  Thanks all for the advice!!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now