Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2010
    Posts
    4

    Lightbulb Unanswered: Build web forms to get data into Access?

    I am looking to build some web forms that will bring information into an Access 2003 database.

    • Any ideas where to start?
    • Any tutorials or rough guides?


    Thanks for any input.

    Happy St. Patty's Day

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Though feasible, using Access as the database engine of a web application is not recommended. The number of simultaneous clients that an Access database is very limited and you'll soon run into a lot of troubles.

    If you really want to do it, see:
    Creating Dynamic Web Pages with Microsoft Access
    Consume Web Service from Access — DatabaseJournal.com
    Connecting To An Access Database Using ASP
    Among many others.
    Have a nice day!

  3. #3
    Join Date
    Mar 2010
    Posts
    4
    Thanks for the reply. My heart is not set on using Access as the engine, definetly not if it will lead to instability.

    Any ideas for easy ways to make online forms that can be easily sent to Access?

  4. #4
    Join Date
    Mar 2010
    Posts
    4
    How about using InfoPath 2003?

    It seems that I can first deisgn the database, then have InfoPath build a form for me. Next I can publish it on the web and find a way to retrieve the data.

    Does this sound reasonable? Any pitfalls?

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I create php scripts which the web designers use to update data in MSAccess tables. It works well but I'd recommend SQL Server instead of MSAccess for optimal performance, especially if it's data that could be constantly updated.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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