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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-28-2017, 02:03 PM   #1
ridders
Registered User
 
Join Date: Jan 2017
Location: Somerset, England
Posts: 786
Thanks: 20
Thanked 172 Times in 168 Posts
ridders will become famous soon enough
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, 216 views)
File Type: png WebCheckerMessage1.png (69.8 KB, 210 views)
Attached Files
File Type: accdb WebVersionChecker.accdb (588.0 KB, 56 views)

__________________
Colin
(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.
)


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment!

Last edited by ridders; 06-05-2017 at 03:10 PM.
ridders is offline   Reply With Quote
Reply

Tags
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 10:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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