SitePoint Sponsor |
|
User Tag List
Results 1 to 8 of 8
Thread: Using FTP Control in MS-Access
-
May 22, 2002, 12:43 #1
- Join Date
- Aug 1999
- Location
- Lancaster, Ca. USA
- Posts
- 12,305
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
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?
-
May 22, 2002, 14:18 #2
- Join Date
- Feb 2001
- Location
- Stockport, UK
- Posts
- 729
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You can FTP from the Command prompt in XP (and 2K I think) if thats any use?
-
May 22, 2002, 16:22 #3
- Join Date
- Oct 2001
- Location
- Whistler BC originally from Guelph Ontario
- Posts
- 2,175
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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 helpsMaybe this way you won't need the access front end
Maelstrom Personal - Apparition Visions
Development - PhP || Mysql || Zend || Devshed
Unix - FreeBSD || FreeBsdForums || Man Pages
They made me a sitepoint Mentor - Feel free to PM me or Email me and I will see if I can help.
-
May 22, 2002, 18:08 #4
- Join Date
- Aug 1999
- Location
- Lancaster, Ca. USA
- Posts
- 12,305
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
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.
-
May 25, 2002, 05:05 #5
- Join Date
- Jan 2002
- Location
- London
- Posts
- 3,509
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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
-
May 25, 2002, 08:10 #6
-
May 25, 2002, 11:28 #7
- Join Date
- Jan 2002
- Location
- London
- Posts
- 3,509
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You can apply the same technique to ASP, given the right permissions...! However, an FTP COM component is always prefereable of course!
M@rco
-
May 29, 2002, 09:39 #8
- Join Date
- Feb 2001
- Location
- PK
- Posts
- 460
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Re: Using FTP Control in MS-Access
Originally posted by W. Luke
I am using OSCommerce on a site of mine.
Bookmarks