Version 2.1           Last Updated 9 Feb 2022           Approx 0.6 MB

Attached is an example web version checker application.
The app demonstrates how users can be alerted to program updates on a specified web page.
You may find this useful if you intend to distribute version updates via the Internet.



The way this app works is as follows:
The code identifies if a new version is available by 'reading' all the contents of the web page to a temporary text file
It then searches the text file for a specified string where the web version number is given.

If the web version is higher than the local version, the user is alerted.
The whole process takes a fraction of a second to complete.

If a new version is available, a message similar to this will appear:


The user can then go straight to the website & download the new version

NOTE:
To demonstrate how the app works, the link will take you to another page on this website.
The latest version listed on the website is 5335 (as of 28/05/2017)

However, there is absolutely no point you downloading the program update listed as it requires a product licence key to install!

If the current version is the latest available, a message similar to this will be shown:


To use this code with your own databases:
1.   Add the VBA reference Microsoft Internet Controls
2.   Import the modules modFunctions & modInternetDownload
3.   Import the table tblLocalVariables or adapt the code to use similar data in another table
4.   The main code is contained in the procedure: CheckLatestWebVersion in modFunctions
      MODIFY the code to suit your own database version numbering and website page contents

In my own production databases, the CheckLatestWebVersion procedure is run automatically from the startup form when the program administrator logs in.
As the program admin manages all updates, standard users do NOT receive the alerts



Version History

v1.0     23/08/2018     Initial release
v2.0     07/10/2019     Bug fixes and changes to simplify conditional complilation for 32/64-bit Access
v2.1     09/02/2022     Updated URL for new web address



Download

Click to download:     Web Version Checker



Feedback

Please use the contact form below to let me know whether you found this article interesting/useful or if you have any questions/comments.

Do let me know if you find any bugs in the application.

Please also consider making a donation towards the costs of maintaining this website. Thank you



Colin Riddington                       Mendip Data Systems                       Last Updated 9 Feb 2022

Return to Example Databases Page

Return to Top