Add info to DB without DB wizard
Hello.
I would like to add info to a Access 97 database from a FrontPage 98 web
without using the database region wizard.
I am purely guessing I need three things to do this:
1) A recordset
2) A method to be used on the recordset
3) Proper SQL syntax for the data I would like to add
I am guessing it would look something like this:
<%
Set rsMySet = CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM Table1"
rsMySet.Open SQL, "DSN=db1"
' With the recordset open, I can now add a record
rsMySet.(some method, perhaps AddNew?)
' Then, perhaps some SQL like:
SQL2 = "INSERT INTO Table1 (Field1) VALUES ('Test Data')"
rsMySet.(some method) SQL2
%>
Am I even close?
Thanks,
Chris Smith
