Using FTP Control in MS-Access

[Hierophant]

Does anyone know of an FTP control that I can use to "publish" files from MS-Access?!?

First me give you a background of what I am trying to do...

I am using OSCommerce on a site of mine. It stores all its data in a MySQL database which is accessed through a web-frontend. Even on the fastest connection this is a slow why to access the data. We are going to have thousands of products. In order to speed the process up, I am building a front-end in MS-Access for a local copy of the database. We will take advantage of forms and reports in Access and store the database in MySQL on the local machine using ODBC.

What I need to do is create a process so we can synchronize the two databases on a daily basis. Uploading new products and inventory amounts and downloading any sales from the previous day for packaging and shipping. I want to do this with as little human intervention as possible and figured a couple PHP scripts and some VBA code in Access could do it. However I need a FTP control that I can use that doesn't cost much (free if possible) since the resulting product would fall under GPL. Anyone know of such a beast? Or a scriptable FTP application?

[sowen]

You can FTP from the Command prompt in XP (and 2K I think) if thats any use?

[Maelstrom]

I am not sure if this is quite what you want but mysql has a built in system for backing itself up to another server.

http://www.devarticles.com/content.php?articleId=62

If you check out the third example you can (at the command line) simply export the dump of the file into another mysql server.

mysqldump --opt mydatabase | mysql --host=localhost -C newdatabase

Hope that helps Maybe this way you won't need the access front end

[Hierophant]

The publishing will be done through Access... I think I am going to use Window's WebFolder's feature with a Secure FTP connection outside the webroot for this after doing some more research.

I can't use MySQL's backup system because I would have to make my web database accept remote commands and that is just a security risk that I am not willing to take.

[MarcusJT]

Check this out:
http://www.swynk.com/friends/lesandr...sXMLExport.asp
(it's not AccessXP-specific, so it'll be fine for 97/2000 too)

M@rco

[Hierophant]

Thanks... I bookmarked that page. It looks interesting and I will review it later this week.

[MarcusJT]

You can apply the same technique to ASP, given the right permissions...! However, an FTP COM component is always prefereable of course!


M@rco

[kashaziz]

Originally posted by W. Luke

I am using OSCommerce on a site of mine.

surely you can help me out... I have tried to install oscommerce on my win2K machine, managed to work out the client section but the admin section gives path errors when i click links ?????