Mendip Data Systems

Database applications for businesses and schools

LogoTransparent

Example Apps for Businesses, Schools & Personal Use

Version 1.0      Updated 28/05/2017              Approx 0.6 MB

 

Attached is an example web version checker application which shows 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 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: the link will take you to this website, www.mendipdatasystems.co.uk

The latest version on the website is 5322 (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:

 

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 of your own

4. The main code is contained in the procedure: CheckLatestWebVersion in modFunctions. You will need to ADAPT this as necessary 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

 

Click to download:  Web Version Checker

Web Version Checker

Click any image to view a larger version ...

Screenshots

CERT Version 1.43

WebVersionCheckerForm WebCheckerMessage2 WebCheckerMessage1 Return to Example Databases Page