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