Check for updates in my application

[Luke Bellamy]

Hi - I am using Acc 2002 and have an app that people currently have to go to
my web site
and check for updates. I would like to implement the automatic check for
updates like so many
other products.
So I'm after a bit of guidance. Should I be using a HTTP post/response to
check for updates,
or winsock (or are they the same) in Access 2002? Is there a best method to
use for this to
avoid problems with security and firewalls etc?
How do other applications do this?

Any links to sample code would be appreciated.
Thankyou.

 

[Danny J. Lesandrini]

I was just thinking about that today. I have code that will read files at an
FTP site. It could, I suppose, determine if the file date was newer than the
last download file date and if so, download the new client.

However, you can't copy over an open Access mdb file with a new version
while it is actively open, so you'd have to pass the process off to another
app and then reopen the original client file (newly updated)

I had written two articles for DBJ. One explained the FTP piece and has
the necessary code, while the other describes the Deploy piece. The deploy
code copies down from a network location, but that code could be replaced
with the FTP call. If I get time, I'll put something together, but all the
pieces are already there.

FTP from Access
http://www.databasejournal.com/features/msaccess/article.php/3513061

Deploy new Client
http://www.databasejournal.com/features/msaccess/article.php/3286111

 

[Luke Bellamy]

The good thing for me is my DB app front end is an instance of a master
copy.
If the master copy is changed during a startup routine check I wrote the
client is updated.
So running the upgrade to the front-end is very painless. Just requires an
app restart when done.

Not really keep on an FTP server so looking at things like WinHttpRequest
objects
as would also like a generic tool in my app to post.
Do you know what the best net comunication objects to use in VBA?

---------------
Luke Bellamy
Newcastle, Australia

I was just thinking about that today. I have code that will read files at
an
FTP site. It could, I suppose, determine if the file date was newer than
the
last download file date and if so, download the new client.

However, you can't copy over an open Access mdb file with a new version
while it is actively open, so you'd have to pass the process off to
another
app and then reopen the original client file (newly updated)

I had written two articles for DBJ. One explained the FTP piece and has
the necessary code, while the other describes the Deploy piece. The
deploy
code copies down from a network location, but that code could be replaced
with the FTP call. If I get time, I'll put something together, but all
the
pieces are already there.

FTP from Access
http://www.databasejournal.com/features/msaccess/article.php/3513061

Deploy new Client
http://www.databasejournal.com/features/msaccess/article.php/3286111

--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast/