Solved

Version update

Posted on 2001-08-06
4
161 Views
Last Modified: 2010-05-02
How do VB programs automatically update themselves when newer versions come out?

Is there a way to do this with an Access 2000 database???

0
Comment
Question by:scorp8
  • 2
4 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 6357380
As far as I know, VB programs don't update themselves.  
The best you're likely to get is that their dependencies will get updated when a newer OCX or dll is installed by the user.

Since you mentioned Access, a project I'm working on will rely on the A-2000 DB for most of its updates--by design.  When we ship a new version of the DB, the customers will get the updates.
0
 
LVL 1

Author Comment

by:scorp8
ID: 6359187
I'm currently developing a db in A2K and the frontend will set locally, while the backend is on the network...  There will be version updates at least once every two to three weeks, and I don't want to go to every single persons terminal to update their copy on their local drive...  I'm working on a few things to update but not sure how it's going to work...

scorp8
0
 
LVL 8

Accepted Solution

by:
DennisBorg earned 20 total points
ID: 6359579
Scorp8:

You can write a little stub VB program which will check the time & date stamp on the local copy of file(s) which might need updating, and compare that with the time & date stamps of the network copy. If the dates on the network copies are later than the dates on the local copies, then this stub program can copy the newer files to the user's local machine. *Then* the stub program can invoke the *real* application program.

The shortcut which your users use will point to this stub program instead of directly to your real program. The stub program may or may not update certain files (depending on how the time & date stamps compare) and then it runs the real program; this makes it completely transparent to the user, and allows you to automatically update your users without having to go to each user's computer (once this is set up)

This will not work with an Access database, however, since the time & date stamp on the MDB file is updated each time it is used. For that, the stub program could check a version table in the local copy and compare with a version copy on the network to see if an update is needed.

You have to be careful, however; for if you simply copy over the database file, then the users will loose their data. So you would probably want to programmatically modify the database.

Since this seems to be a multi-user application, the database is probably on the network anyway. So your stub program probably should not be concerned with the database, just the EXE file and perhaps some associated files (such as DLL's, data files stored locally, etc) In this case, you would have to modify the database on the network while nobody is using the database, which may mean that you have to "bring the program down" (i.e. ask everyone to quit the program) for maintenance. Once you've completed your maintenance on the database, then the users can start using the program again.


-Dennis Borg
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 6360068
Great idea, Dennis!

So to summarize:

Replace the Access link with a link to a Windows/VB program which:
* checks for updates
* downloads and installs those updates as necessary
* starts Access
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question