Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

Thread Tools Rate Thread Display Modes
Old 05-28-2017, 02:03 PM   #1
Gold Supporter
ridders's Avatar
Join Date: Jan 2017
Location: Somerset, UK
Posts: 3,362
Thanks: 60
Thanked 774 Times in 717 Posts
ridders has a spectacular aura about ridders has a spectacular aura about ridders has a spectacular aura about
How to create a web version checker

If you distribute version updates via the Internet, you may find this useful.

Attached is an example web version checker database which shows how users can be alerted to program updates on a specified web page.

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

In the attached example, you can see this in action:

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 my 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 as necessary to suit your own database version numbering and website page contents

In my own production databases, the CheckLatestWebVersion procedure is run automatically when the program administrator logs in
Attached Images
File Type: png WebCheckerMessage2.png (84.1 KB, 633 views)
File Type: png WebCheckerMessage1.png (69.8 KB, 604 views)
Attached Files
File Type: accdb WebVersionChecker.accdb (588.0 KB, 181 views)

Mendip Data Systems
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk

If this answer has helped, please:
Click the Thanks button and/or click the 'reputation' scales symbol on the left, tick 'I approve' and leave a comment. Cheers!

Last edited by ridders; 06-05-2017 at 03:10 PM.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
usm01 (07-25-2017)

version update check , web version checker

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create New table entries when new record created, Any Version aray213 Modules & VBA 0 09-21-2010 07:33 AM
How to Create Employee's Monthly Production Report in MS Access Version: 2007 pavinm Reports 3 05-05-2009 08:29 AM
Create a Data Definition Schema Wizard version 2.0 DCrake Sample Databases 6 01-28-2009 04:11 AM
Create a 30-day trial version with MDT-2000 StefanSch Forms 5 02-10-2003 09:42 PM
Create a 30 days trial version with MDT-2000 StefanSch General 0 01-28-2003 10:00 PM

All times are GMT -8. The time now is 11:58 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World