Microsoft Excel Webinar

Results 1 to 6 of 6

Thread: Is it possible to automate data entries from a website into a ms access form?

  1. #1

    Is it possible to automate data entries from a website into a ms access form?

    Hi experts, I would like users to enter data on a from on a website, and the data entered would automatically populate fields on a form with identical field names in Access. Is this possible to do, if so how can this be done? Would you have any sample code or websites that have sample API code to do this?


    Thanks for your contributions

  2. #2
    If the database was on the same server as the webpages then this would be possible but then you would need some kind of remote login to be able to use the database.

    I've heard the new version of Access (possibley released later this year) is going to solve this problem. But we will have to wait and see...
    Regards
    JD
    ------------------------------------
    Bespoke Access Database Design

    VBA Programmers

  3. #3
    Quote Originally Posted by SoftwareMatt
    If the database was on the same server as the webpages then this would be possible
    Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?

  4. #4
    Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?
    Not sure I understand your point/question.

    Yes IIS and asp work together and will be used on the webserver but if you want to pass the data from the webform to the database then the database will need to reside on the same server that's all I'm saying.
    Regards
    JD
    ------------------------------------
    Bespoke Access Database Design

    VBA Programmers

  5. #5
    Quote Originally Posted by SoftwareMatt
    Not sure I understand your point/question.

    Yes IIS and asp work together and will be used on the webserver but if you want to pass the data from the webform to the database then the database will need to reside on the same server that's all I'm saying.
    Right, and I thought the OP indicated they would reside the same.

  6. #6
    Here is another option. I use a remote web site that have a SQL server (mySQL, Microsoft SQL Server, Oracle, etc.) as the back end. The remote webs site can use ASP/, ASP.net, PHP or your favorite scripting language to store data in the SQL Server.

    The remote SQL server is set up for remote connections. From the Access application on the users desktop they can import the data from the remote SQL server into their Access application.

    The key is being able to make an ODBC connection to the remote SQL server. This allows you to directly extra the data.
    Boyd Trimmell aka HiTechCoach
    Microsoft MVP - Access Expert

    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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