What is the simplest way to set up a query form online to then plug into Access?

Question

I want to experiment with putting a form on a website. Then take the answers from the filled form and viewing those answers in Access to be linked directly into a db.
Any ideas? How do I create the form, ASP, html? I know connection using ODBC from ASP to Access can work - I need more info around the issue generally.. alternatives etc.

Thanks

Answer 1

This is a very broad question, but your easiest method would be to do the following.

Using Visual Web Developer Express (Or full Visual Studio if you have it). Create a web applciation using ASP.NET and your language of choice.

Add the Access Database to the website in the App_Data folder of the project, and depending on your specific needs, from here you can use a lot of the drag-drop items to build the page up.

A few notes.

1. Using the drag and drop items are great for rapidly putting up a site, but do not follow best practices.
2. 4guysfromrolla.com is a great reference for the how-to's on the ASP.NET side of things
3. Access IS NOT necessarily the best choice for a database engine for a website...but can work.

Answer 2

Do not forget that you can use a parameter query in Access and update that, it is more secure.