Posting Form Data to an Access (or SQL) Database

[chrison600]

Hi all,

Some time ago, I wrote code to append form data to an Access database, and have since lost the code. Does anyone have hints or a link to a tutorial that explains how to write VB/ASP to save form data to a database (Access or MS SQL preferably)?

Thanks!

Chris

[Corey Bryant]

Check out Programming Resources, Tutorials, etc, ASP 101, ASP Alliance,15 Seconds, and Four Guys from Rolla

[ADAM Web Design]

www.haneng.com has some great tuts as well, even though the guy hasn't updated the site in a dog's age. I use it more for the occasions when I forget a function and how it works than anything (he's got them all listed there), but there are Access tuts as well in there.

After that, I'd go with Corey Bryant's suggestions of 4 Guys from Rolla (that site ROCKS!) and ASP 101 (where I cut my teeth.) Smart guy, that Corey.

If you code your SQL statements correctly, MS Access and SQL Server are basically the same code. The only major difference that I can think of is that with Access, you code dates like #12-31-2004# whereas with SQL Server you code them '12-31-2004' (in other words # vs ').