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.
 
Thanks. Is this a free solution or does it have to be registered to work
properly ?
 
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.
 
well, this is not available in current version, but of course possible to
make
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Packaging and distribution... 4
VBA to check for latest version of front end? 11
Access Access, Error Due to Versioning Differences 0
Killing Excel process from Acess2000 VBA 4
Access Issue, Macro Single Step, Error 3270 0
Access AutoExec, Runcode Error 2001 1
Runtime etc. 6
Need a little advice on frontend - backend set up... again. 1

Back
Top