Example Apps for Businesses, Schools & Developers

Click any image to view a larger version

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.

WebVersionCheckerForm

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:

WebCheckerMessage1
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, https://isladogs.co.uk/sda-update/
The latest version listed on the website is 5335 (as of 28/05/2017)
However, there is 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:

WebCheckerMessage2
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



Click to download:     Web Version Checker



Colin Riddington           Mendip Data Systems                 Last Updated 9 Feb 2022

Return to Example Databases Page Return to Top