Access upload to an ftp page

[mjwillyone]

I have an access database that I would like to upload daily to an ftp page on the Internet. I need to come up with a way to automate this process so that a secretary that knows little about uploading will simply have to click a button and the database will automatically upload. I know the ftp site location as well as the place on the local computer where the Access database is kept.

Thanks for your help,
Mike

 

[FoFa]

Why not just create a .BAT file and use the bultin FTP with Windows? You can create a Desktop ICON to the .BAT file if you need to.

 

[mjwillyone]

I would love to create a bat file that will do this. But, I do not even know where to begin. I have used Winbatch and created a number of batch files running in windows, but never anything like this. Any code suggestions?

Thanks.

 

[BCullenward]

or you could just make a VB program to do this

 

[Meltdown]

...another option from mvps
http://www.mvps.org/access/modules/mdl0037.htm