Can I have an HTML Form write directly to my MS Access Database on my computer?

Posted on 2007-07-30
Medium Priority
Last Modified: 2010-04-09

I have an HTML Form (http://www.executivedecision.biz/forms/DocEPW.html) that my new candidates fill out.  Right now it is using MySQL to write to a DB on my Web Host's Server.

I then do a TransferDatabase to get this into my Access Database.  Is there a way I can set up my computer as a Server and just have the form send the data directly into my Access Database when people fill it out?
Question by:MitchellVII
  • 3
LVL 25

Accepted Solution

SStory earned 1600 total points
ID: 19591841
Sure there is a way, (assuming you mean using a back end ASP/ASP.net or other type code, and  if you have a fixed IP DSL connection or such on your local machine, and it is always on and available, you could run the entire website on your box with IIS or Apache and change the DNS settings to write to Access. You could also install MySQL on your local box and have it there.

These aren't simple to do, and you will have to understand the coding and how to set up each of these pieces.  MySQL and SQL Server can be called via TCP/IP address, and thus your webpage could write to a SQL Server or MySQL server anywhere.


Assisted Solution

sundaramkumar earned 400 total points
ID: 19591992
you can use dsn/dsn less connection to db and have to use ASP or anyother serverside scripting to open the access database
LVL 25

Assisted Solution

SStory earned 1600 total points
ID: 19594843
Sure you can...... but if this is a busy site, you probably shouldn't... in terms of depending on Access for the live database on a big site.  If it is a small site, then you have many options for such apps.

Author Comment

ID: 19594968
Hey guys, thanks for all the good responses.

I just decided to host with GoDaddy instead because they have Windows Servers and Access online.
LVL 25

Expert Comment

ID: 19595576
That's great!

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The first step to building an amazing About page is to figure out what you want the page to say about your company. You then must grab the attention of the reader, boast a bit, tell a story and let others brag about you. With a little bit of thought…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
Suggested Courses
Course of the Month14 days, 22 hours left to enroll

840 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