Using FTP Control in MS-Access
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?
Re: Using FTP Control in MS-Access
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 ?????
Originally posted by W. Luke
I am using OSCommerce on a site of mine.