Connecting to Access Database and editing/adding records

[tyleri]

Does anyone know of a website with step-by-step instructions on how to put together a form that will add entries into an Access database? All I want to do right now is to be able to add entries via an online form, and also edit current entries, also on an online form. I am out of luck w/ the search myself. I'd appreciate any help!!!

 

[sweevo]

http://www.devguru.com/features/tutorials/ADOandASP/adoTutorial.html

will show you the basics of database stuff with asp, if that's of any use. As for adding and editing, check out the Jet SQL section of the same site (DevGuru) for UPDATE and INSERT SQL statements and use these in the way it shows for a DELETE operation.

Assuming you understand ASP and VBScript basics, simply build a form with inputs for the values you want to update, post it to a new ASP and use request.form("formItemName&quot to build up your SQL, then execute it on the ADO connection.

Hope that's at least a decent starting point.