Access an HTML

Posted on 2011-10-30
Medium Priority
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

Expert Comment

ID: 37055138
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 37055623
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

ID: 37060887
Thanks tutorial was really helpful

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

809 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