automatic update of database over internet

[Jesper F]

I have a split, secured, multiuser db running with the AutoFEupdater. I
regularly send updates of the FE to my contact person on site via email and
he places the new FE in the right folder on the network drive.
I think it would be cool to have the FE update itself via the internet.

I'm thinking of a solution along these lines:
I was thinking of a solution where, when a user is logged in the
application, the db checks (with some interval) whether a new version is
available. I'd place the new version for download via my website (how
excactly to do this is what this post is about). If a new version is
available, it should be downloaded and placed in the right location on the
network drive.
This a feature of a lot of software today, but I don't know if it could be
done with an Access database.

Does anyeone have any input to as to how this could be done?
Thanks.


Jesper, Denmark

 

[David C. Holley]

You're probably looking for some VBA code that automates a file transfer
via FTP. As that is probably as old as the internet. How to do that via
VBA is beyond me though.

 

[Jesper Fjølner]

You're probably looking for some VBA code that automates a file transfer

via FTP. As that is probably as old as the internet. How to do that via
VBA is beyond me though.

You're right I think. I found this, which I'll try to alter into an
automatic update solution
http://www.databasejournal.com/features/msaccess/article.php/3513061

 

[Tim Ferguson]

You're probably looking for some VBA code that automates a file
transfer via FTP. As that is probably as old as the internet. How to
do that via VBA is beyond me though.

You can GET and PUT files using the XMLHTTP.dll library. There are lots
of pages in Google: try this one

http://puremis.net/excel/code/050.shtml


The bigger problem will be to get your application to close itself,
delete itself and copy the new file over itself, while it's still
running...


Hope that helps


Tim F

 

[David C. Holley]

If you have any experience with *.ASP you *should* be able to create a
*.ASP page that takes a username & password and if valid FTP's the file
from one server to another overwritting the existing Front End.

David H