473,320 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Jan 24 '08 #1
4 1771
On Thu, 24 Jan 2008 14:46:49 GMT, "Michiel Rapati-Kekkonen"
<mi*****@nonsense.zzwrote:

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
Jan 24 '08 #2
"Michiel Rapati-Kekkonen" <mi*****@nonsense.zzwrote:
>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/
Jan 25 '08 #3
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" <mi*****@nonsense.zzwrote in message
news:tx**************@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

Jan 25 '08 #4
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]" <tt****@telusplanet.netwrote in message
news:77********************************@4ax.com...
"Michiel Rapati-Kekkonen" <mi*****@nonsense.zzwrote:
>>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/

Jan 25 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Almoni | last post by:
Hi, I have a few .xsd files that include each other in the following way: <!-- lets call the main schema file AA.xsd and it includes BB.xsd inside it --> <xs:schema...
3
by: Garry Dawkins | last post by:
Hey Frank, I'm a novice with this taking over someone elses application. I'm attempting to add a dataset to a page. I have the query to populate the page and I have the walkthrough instructions. ...
1
by: jtsree | last post by:
I am Using (Windows XP) Visual Studio.net 2003 professional edition working on VB.net language. I am bulding a very very simple project in VB.net where i connect to Access Database by dragging...
9
by: Henk Verhoeven | last post by:
We are not alone! "Where other MDA tools are generating programmingcode, Codeless chooses not to generate code at all". OK, phpPeanuts is not an MDA tool (it has no fancy modeling GUI). But it...
4
by: Stephen | last post by:
I need to generate input XML for another application by serialising classes defined in an XSD document. The code below will generate the XML I require but I need to generate this in memory rather...
1
by: A Traveler | last post by:
Hello, i am having this problem. The exact error message is: "Unable to generate code for a value of type 'System.Web.UI.Page'. This error occurred while trying to generate the property value for...
8
by: mortb | last post by:
Hi, How do I write a GenerateHashcode function that will generate guaranteed unique hashcodes for my classes? cheers, mortb
0
by: ward | last post by:
Greetings. Ok, I admit it, I bit off a bit more than I can chew. I need to complete this "Generate Report" page for my employer and I'm a little over my head. I could use some additional...
2
by: bthubbard | last post by:
This may not be the best group in which to post this. If there is a better location please direct me there. I have been experimenting with Sandcastle to generate CHM help file documentation for...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.