Access an HTML

Posted on 2011-10-30
Last Modified: 2013-11-27
Hi guys

Is there any way I can connect Html to Access DATA BASE and using the HTML Form I can update the data in Access Table, Any help is appreaciated
Question by:surah79
    LVL 9

    Expert Comment

    You must need any script language you cant perform any dtabase operation with any database using simple html...

    1) Either you need to submit heml form to result.asp or any other script language page

    After Successfull execution redirect back to html page.

    if any error comes redirect back to error html page.

    2)  Put iframe inside html page anf submit form to .asp page.

    so user will never get aware that we used any script .asp page as it will never get display its url in browser.

    and follow above method.

    Hope this helps

    LVL 84

    Accepted Solution

    Are you asking if you can use an HTML Form to update an Access database? An HTML Form is just a form where users fill out data. You'd have to take steps AFTER that to move the data into the Access database, and you'd have to use some other method to actually move that data - HTML is just a markup language that presents a page in your browser. It cannot work with data like ASP or PHP.

    Here's a little tutorial that walks you through working with an access database from ASP:

    Note also that your Access database would need to be on the same machine or Network as the machine running the ASP/PHP. Access doesn't handle remote connections, so you could not run an ASP application on your webserver and update the Access database on your workstation.

    Author Closing Comment

    Thanks tutorial was really helpful

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now