Retrieving mde version info

[John]

Hi

Is there any version info saved in an mde that differentiates one compile
from another? Ideally I need to be able to pass this info to a vbscript that
decides to copy the file if it is newer than the existing file.

Thanks

Regards

 

[Jack Cannon]

John,

Here is the way that I do it.
I use a public constant such as:
Public Const datVersion = #3/6/2009#

The version is displayed on the application title bar.

After compile I archive it as:
MyApp090306.mdb
and distribute it as:
MyApp090306.mde

If you really need the vbscript to read the version number then you will
probably have to store the version number in a text field of a table in the
application that the script module can link to.

Jack Cannon

 

[Tom Wickerath]

Hi John,

Ideally I need to be able to pass this info to a vbscript that
decides to copy the file if it is newer than the existing file.

Access MVP Tony Toews has a free "AutoFE Updater" utility that you might
really like using. More details here:
http://www.granite.ab.ca/access/autofe.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________