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

    Move data from local MDB to Internet Database (Access 2000/VBA/ASP)

    Greetings All,

    Please forgive me if this post would be more appropriate in other forums. It seems to apply equally to Access, Internet, and VBA...

    I need ideas for a solution to transport records from a local Access database (multiple copies) to an Access database stored on the internet.

    I am currently using ADO and the Internet Explorer ActiveX control (ShDocVw.dll) to send data to a simple ASP file using the GET method - just like one would pass data with a web-form.

    My current method works fine, but I was curious to know if anyone had other ideas that would be more reliable or work even better.

    Additional information:
    -This all happens behind the scenes in an Access form, so the user never sees a browser window

    -The Internet database would be secured (with MDW) and the username/password would be passed with each record.

    -On the local database I'm using an ADO recordset to loop through the records and submit each one to the url (with the GET parameters):
    objIE.Navigate URL:="http://.../submit.asp?user=test&pwd=test&field1=test&(etc...) "

    -As the ASP page receives each record, it writes it to the database

    -I notice there's a POST argument in the Navigate method of the Internet Explorer object, but I couldn't find any instructions on syntax in the documentation

    Thanks in advance for any ideas! <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Move data from local MDB to Internet Database (Access 2000/VBA/ASP)

    I actually think this might be the most straightforward way to do it, assuming the back end is an MDB as well. There are probably other options for writing to the database, but moving from ASP to the next thing could require a lot of server-side changes and there's no guarantee of better performance or equivalent transparency.

    The POST method would require you to submit your data as part of a form rather than in the URL. However, if you are transmitting over the Internet (as opposed to within a network) this might help prevent username/password sniffing and better protect the data itself. The form body is readable (unless you use HTTPS), but it doesn't get logged by the firewalls and routers along the way, as does a URL.

    That said, I'm not very experienced with Internet development, so I certainly don't pretend to be an expert!

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

    Re: Move data from local MDB to Internet Database (Access 2000/VBA/ASP)

    Hi Jefferson,

    Thanks for your response. It seems that we're thinking along the same lines.

    The back-end DB is also MDB.

    I'm using the Web Browser Automation Control object in an Access form's module to send the data, so I'm not really worried about the user seeing the GET parameters. I plan to keep the object hidden.

    The data isn't really sensitive (especially not enough to require HTTPS). But all the same, I wouldn't leave an ASP file with record writing capabilities on a web server without some kind of password protection.

    This is only a part of a larger solution - starting with a data collection app on PocketPCs, synchronizing with an MDB on the desktops, then passing data to a single database on the internet, finally downloading for processing (all in Access).

    Thanks again for your response! I'll let you know how the app turns out. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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