Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transfer from AccXP BE to Web (Access 2002)

    When a record is created locally, I'd like to be able to add the record to an existing table residing on the Web. So far I've had no joy linking to a web backend. At this point we'd be more than willing to entertain pushing a copy of relevant tables to the webserver via FTP on a scheduled basis but haven't been able to find a way to do that through automation. I've searched the archive and all I can really find are discussions of specific problems but not the basics. Can anyone point me in the right direction bearing in mind at this point I'm totally clueless. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Transfer from AccXP BE to Web (Access 2002)

    I'm sorry, Brian, but what is it you're trying to automate, writing a record to a table on the web, pushing a copy of tables to a web server, or something else? As far as I can tell, you're talking about using an AXP back end to a web application, but what is the "local" part?
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer from AccXP BE to Web (Access 2002)

    Thanks for your interest Charlotte. I have a LAN consisting of Access XP Front Ends on workstations connected to a Win2000 server hosting the Access Back End.
    We want to enable Web Users to access specific records created on the LAN. We have created a database on a remote Web Server to hold these records and they are accessed through ASP script. So far, the only way we have been able to update the Web Server is by pushing the tables via FTP using brute force.
    Although writing a record to the Web Server at time of local creation/modification is attractive since it keeps the Server current, I can see how it could be cumbersome ensuring the data is truly matched in both databases. A certain delay in updating the Web Server is not a terrible problem so right now we're looking for a way to schedule an update or make table query and automatically push the table to the Web Server replacing the existing table.
    Probelm is, I don't have a clue how to establish a connection from AccXP to the Web Server either to export the table or update the Web Server table.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer from AccXP BE to Web (Access 2002)

    Hi Brian,

    It sounds like your Web Server is remote - is this correct? If so, you're correct - automating FTP is about the best way to run things under the circumstances. (By the way, to automate the process you could write a simple DOS FTP command, then assign it to run at a desired time in the Windows Task Scheduler...)

    One other possible solution would be to use Database Replication to keep things synchronized between web server and local users. I haven't used this before, but I understand that it exists just for situations like this.

    Hope this helps

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transfer from AccXP BE to Web (Access 2002)

    Cheers Mark <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Took your advise and shell to an ftp .txt batch file which I can fire from a button or timer event. Works just fine. Thanks again.

Posting Permissions

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