Need to download data to local access database

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Need to download data to local access database

    Have a web app (ASP classic) that saves data to an Access database on
    the web host. Need to come up with some sort of ASP admin tool that
    will download the data from that web database and save it in a local
    Access database.

    Anyone have any ideas how to do this? I've done a search of tutorials
    with no success

    Jay
    jv Guest

  2. Similar Questions and Discussions

    1. connecting Access database on local apache server
      I have coldfusion installed as a multiserver configuration running on both Apache and IIS. Is it possible to use coldfusion MX7 to connect to an...
    2. Transfer data from Internet to local database
      I use a database on the internet from wich I retrieve Orders placed. I want to save the retrieved information to my local disk, and from there...
    3. Problem connecting to local Access database - Unable to open registry key 'Temporary (volatile) Jet DSN ...
      Hi I get the following error sporadically when running a sample in an MSDN ASP tutorial: Microsoft OLE DB Provider for ODBC Drivers: General...
    4. Can local ASP page access remote database?
      Can I have a local (using PWS on Win98) ASP page access a database over the Internet? I have an MS-Access database on a Web site that is updated...
    5. Protect local data files from download?
      Just make sure that the extension of the file is unkown to IIS. Give the file a name like data.xyz or something. Then IIS will never serve it up...
  3. #2

    Default Re: Need to download data to local access database

    An MDB is just a file. Why not FTP it down?

    "jv" <jayvolk@nospampleasebellatlantic.net> wrote in message
    news:d3m0m1$ke6$1@forums.macromedia.com...
    > Have a web app (ASP classic) that saves data to an Access database on the
    > web host. Need to come up with some sort of ASP admin tool that will
    > download the data from that web database and save it in a local Access
    > database.
    >
    > Anyone have any ideas how to do this? I've done a search of tutorials
    > with no success
    >
    > Jay

    Les Matthews Guest

  4. #3

    Default Re: Need to download data to local access database

    Yep, understand that (I've created the application already)... problem
    is I don't want to give clients FTP access and they don't want to have
    to bother me for downloading each time.

    jv

    Les Matthews wrote:
    > An MDB is just a file. Why not FTP it down?
    >
    > "jv" <jayvolk@nospampleasebellatlantic.net> wrote in message
    > news:d3m0m1$ke6$1@forums.macromedia.com...
    >
    >>Have a web app (ASP classic) that saves data to an Access database on the
    >>web host. Need to come up with some sort of ASP admin tool that will
    >>download the data from that web database and save it in a local Access
    >>database.
    >>
    >>Anyone have any ideas how to do this? I've done a search of tutorials
    >>with no success
    >>
    >>Jay
    >
    >
    >
    jv Guest

  5. #4

    Default Re: Need to download data to local access database

    You could just provide them with a link to download the database.

    --
    Jules
    [url]http://www.charon.co.uk/charoncart[/url]
    Charon Cart 3
    Shopping Cart Extension for Dreamweaver MX/MX 2004


    Julian Roberts Guest

  6. #5

    Default Re: Need to download data to local access database

    The database is at a level ABOVE the web root...unfortunately.

    jv

    Julian Roberts wrote:
    > You could just provide them with a link to download the database.
    >
    jv Guest

  7. #6

    Default Re: Need to download data to local access database

    Havent used Access for a long long time, but have a look at Linked Tables or
    the Replication Features, might be able to do what you need.


    --
    Gareth - TMM Dreamweaver
    [url]http://www.dreamweavermxsupport.com/[/url]
    [url]http://www.garethdp.com/[/url]

    PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
    [url]http://www.phploginsuite.co.uk/[/url]

    Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
    Co-Author: Practical Intranet Development - Apress
    Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
    Co-Author: Dreamweaver MX: PHP Web Development - Wrox


    gareth Guest

  8. #7

    Default Re: Need to download data to local access database

    Maybe have a look at Tom Muck's Force Download extension on
    [url]www.basic-ultradev.com[/url]

    --
    Jules
    [url]http://www.charon.co.uk/charoncart[/url]
    Charon Cart 3
    Shopping Cart Extension for Dreamweaver MX/MX 2004



    Julian Roberts Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139