Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

Update Program

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!
3 Solutions
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Tony's Auto FE Updater is pretty much the de-facto standard:


Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
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.
russell12Author Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now