SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    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?
    Wayne Luke
    ------------


  2. #2
    SitePoint Guru sowen's Avatar
    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?

  3. #3
    What? Maelstrom's Avatar
    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 helps Maybe 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.

  4. #4
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    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.
    Wayne Luke
    ------------


  5. #5
    The doctor is in... silver trophy MarcusJT's Avatar
    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

  6. #6
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Thanks... I bookmarked that page. It looks interesting and I will review it later this week.
    Wayne Luke
    ------------


  7. #7
    The doctor is in... silver trophy MarcusJT's Avatar
    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

  8. #8
    SitePoint Evangelist kashaziz's Avatar
    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.
    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 ?????


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •