generate a versionnumber

Hi,

I would like to generate a versionnumber (and save it in a internal table)
on the moment I make a mde.

Then there would also be such version tabel in the central, linked data mdb.
When the mde is opened it checks if the number in the datafile is higher,
lower or the same.
If it is lower than it's own, it would update the number in the datafile.
If it is lower it knows that there is a newer version of the application and
dispalys a message to urge the user to fetch it.

Is this a good plan?
And is it possible?

Thanks for your help

Michiel

Re: generate a versionnumber

On Thu, 24 Jan 2008 14:46:49 GMT, "Michiel Rapati-Kekkonen"
wrote:

Yes.
Yes.
In our company we have a "launcher" program that does the version
check, automatically downloads a new version, and fires up your
application.
I believe Tony Toews' updater program does something similar. I'm sure
you can find his site.

-Tom.


>Hi,
>
>I would like to generate a versionnumber (and save it in a internal table)
>on the moment I make a mde.
>
>Then there would also be such version tabel in the central, linked data mdb.
>When the mde is opened it checks if the number in the datafile is higher,
>lower or the same.
>If it is lower than it's own, it would update the number in the datafile.
>If it is lower it knows that there is a newer version of the application and
>dispalys a message to urge the user to fetch it.
>
>Is this a good plan?
>And is it possible?
>
>Thanks for your help
>
>Michiel
>

Re: generate a versionnumber

"Michiel Rapati-Kekkonen" wrote:

>I would like to generate a versionnumber (and save it in a internal table)
>on the moment I make a mde.

You could create a subroutine which you always call to do the version number update
and make the MDE which would have the following code in it.

You can automate MDE creation with the Application.RunCommand method, using
acCmdMakeMDEFile as the argument, either in code or with a macro.

For Access 97 use SysCmd 603, "CurrentMDBName.MDB", "MDEName.MDE"

>Then there would also be such version tabel in the central, linked data mdb.
>When the mde is opened it checks if the number in the datafile is higher,
>lower or the same.
>If it is lower than it's own, it would update the number in the datafile.
>If it is lower it knows that there is a newer version of the application and
>dispalys a message to urge the user to fetch it.
>
>Is this a good plan?
>And is it possible?

Sure is. But the Auto FE Updater just looks to see if the date/time of the MDE, and
other files, on the server has changed. If they're changed it automatically copies
down the new files. Now given that Access updates the date/time of the MDE/MDE
while the user is in it the date/time of the files on the server are stored in an INI
file on the workstation.

There are links to such sample code out there on the page mentioned below.

I specifically created the Auto FE Updater utility so that I could make changes to
the FE MDE as often as I wanted and be quite confident that the next time someone
went to run the app that it would pull in the latest version. For more info on the
errors or the Auto FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up
to date.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: generate a versionnumber

And, for a simpler approach to "versioning", see the article on the subject
at http://accdevel.tripod.com.

Larry Linson
Microsoft Access MVP

"Michiel Rapati-Kekkonen" wrote in message
news:tx1mj.188$8Z6.38@read4.inet.fi...
> Hi,
>
> I would like to generate a versionnumber (and save it in a internal table)
> on the moment I make a mde.
>
> Then there would also be such version tabel in the central, linked data
> mdb.
> When the mde is opened it checks if the number in the datafile is higher,
> lower or the same.
> If it is lower than it's own, it would update the number in the datafile.
> If it is lower it knows that there is a newer version of the application
> and dispalys a message to urge the user to fetch it.
>
> Is this a good plan?
> And is it possible?
>
> Thanks for your help
>
> Michiel
>

Re: generate a versionnumber

Thanks all for your tips

I decided to register the date/time every time I open the app as long as it
is mdb
this info is not registered anymore when the app is an mde.
hence the mde has the latest possible date.
from then on it checks and if neccesary updates the versiondate field in the
central data.
if it encounters a newer date it gives a message: fetch update.

should do the trick.

to automate the mde making is for me no neccessity.
but if it would be possible to install the update automatically, ha, that
would be really interesting!
I will study the Auto FE Updater.

Michiel



"Tony Toews [MVP]" wrote in message
news:77eip3ppesmg1st2d7ksg6mencmbcsooq0@4ax.com...
> "Michiel Rapati-Kekkonen" wrote:
>
>>I would like to generate a versionnumber (and save it in a internal table)
>>on the moment I make a mde.
>
> You could create a subroutine which you always call to do the version
> number update
> and make the MDE which would have the following code in it.
>
> You can automate MDE creation with the Application.RunCommand method,
> using
> acCmdMakeMDEFile as the argument, either in code or with a macro.
>
> For Access 97 use SysCmd 603, "CurrentMDBName.MDB", "MDEName.MDE"
>
>>Then there would also be such version tabel in the central, linked data
>>mdb.
>>When the mde is opened it checks if the number in the datafile is higher,
>>lower or the same.
>>If it is lower than it's own, it would update the number in the datafile.
>>If it is lower it knows that there is a newer version of the application
>>and
>>dispalys a message to urge the user to fetch it.
>>
>>Is this a good plan?
>>And is it possible?
>
> Sure is. But the Auto FE Updater just looks to see if the date/time of
> the MDE, and
> other files, on the server has changed. If they're changed it
> automatically copies
> down the new files. Now given that Access updates the date/time of the
> MDE/MDE
> while the user is in it the date/time of the files on the server are
> stored in an INI
> file on the workstation.
>
> There are links to such sample code out there on the page mentioned below.
>
> I specifically created the Auto FE Updater utility so that I could make
> changes to
> the FE MDE as often as I wanted and be quite confident that the next time
> someone
> went to run the app that it would pull in the latest version. For more
> info on the
> errors or the Auto FE Updater utility see the free Auto FE Updater utility
> at
> http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on
> each PC up
> to date.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/