versioning Access apps

  • Thread starter Thread starter Silvester
  • Start date Start date
S

Silvester

Hi,

What is the best way to add application version functionality into a A2000
frontend ?

Can someone point me to a how-to url ?

Thanks
 
I would also like to know how to be able to compare version on a users
machine with that on a web server and if necessary download the latest
version
 
Silvester said:
Hi,

What is the best way to add application version functionality into a A2000
frontend ?

Can someone point me to a how-to url ?
Click to expand...

There are several ways to do this. Adding a version table that the
application checks for the highest number is one way. I prefer to create and
use a custom database property. I show the property here as a long, but also
use dbText so I can use it with versions like "1.01a":

Sub CreateVersion()
Dim db As DAO.Database
Set db = CurrentDb
db.Properties.Append db.CreateProperty("AppVersion", dbLong, 123)
Set db = Nothing
End Sub

Sub UpdateVersion()
Dim db As DAO.Database
Set db = CurrentDb
db.Properties("AppVersion").Value = 1
Set db = Nothing
End Sub

Function GetVersion()
Dim db As DAO.Database
Set db = CurrentDb
GetVersion = db.Properties("AppVersion").Value
Set db = Nothing
End Function
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks Arvin,

The starter.mdb looks great. Is there any documentation that goes with it ?
I'm trying to figure it out.
 
actually this is a free solution (works without limitations), but some
people have registered it, to have updates and support in large
organizations
 
How can I take this one step further and check current user fe version and
compare it against what's currently available at the app website.

If there is a newer version available at the website I'd like users to be
able to download it and update the app.

Thanks for any help.
 
Back
Top