Automatically pull/push a new version of Application

[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?

 

[Rick Brandt]

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?

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.

 

[Rick Brandt]

it?

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