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

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

I have an HTML Form ( 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
    LVL 25

    Accepted Solution

    Sure there is a way, (assuming you mean using a back end ASP/ 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.

    LVL 9

    Assisted Solution

    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

    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.
    LVL 5

    Author Comment

    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

    That's great!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
    Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
    In this tutorial viewers will learn how add a full-size background image to a webpage using CSS3. Create a new HTML document with an internal stylesheet.: In CSS, define the html element to have a background image. Use a high resolution image.: In t…
    In this tutorial viewers will learn how to code links for mobile sites that, once clicked, send a call or text to a specified number. For a telephone link (once clicked, calls a number), begin with a normal "<a href=" link tag. For the href, specify…

    728 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

    14 Experts available now in Live!

    Get 1:1 Help Now