Automatically pull/push a new version of Application

  • Thread starter Thread starter Tom McCormack
  • Start date Start date
T

Tom McCormack

I have an access application that is being used throughout
the company. I track the version of the application and
would like to compare the current version to the version
being used by the user. I keep the current version number
in a SQL table that is linked to the access application.
If the user is not using the new version, I would like to
automatically pull/push it to their local machine. Is
there a way to do this with access?
 
Tom McCormack said:
I have an access application that is being used throughout
the company. I track the version of the application and
would like to compare the current version to the version
being used by the user. I keep the current version number
in a SQL table that is linked to the access application.
If the user is not using the new version, I would like to
automatically pull/push it to their local machine. Is
there a way to do this with access?
Click to expand...

This shortcut to my app actually opens a small Access app I call VersionChecker. It
compares the rev number in the local table of the main app with the latest rev on the
server. If a newer one is available the main app's file is copied over and then
launched. If the local rev is current I just immediately launch the main app. In
either case the VersionChecker app closes itself. Has been working for me for
several years without any problem.
 
Tom McCormack said:
it?
Click to expand...

Well, you can't. It's a custom solution for my specific needs although I suppose it
would not take all that much to tweak it into something more generic. Tony Toews has
a free utility that is generic that does something similar. I believe it uses
creation dates instead of a version table. Check out at link below.

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