OK, I'm very new at this. I have an Access database and I've made a connection to it. My web page shows the 4 records I just typed into the Access database.
Is there a good example any of you know of that would help me code (I'm writing in VB Script) to let users add and edit records on their own?
Here is what I have written so far ---
<%
dim RecSet
dim objConnection
Set objConnection=Server.CreateObject("ADODB.Connection")
objConnection.Open "test"
'Set RecSet = Server.CreateObject("ADODB.Recordset")
Set RecSet = objConnection.Execute("SELECT * from Contact")
RecSet.MoveFirst
Response.Write"<TABLE border='1' cellpadding='3' cellspacing='2'>"
Response.Write"<TR>"
Response.Write"<TD>" & "Name" & "</TD>"
Response.Write"<TD>" & "Occupation" & "</TD>"
Response.Write"</TR>"
Do while NOT RecSet.EOF
Response.Write"<TR><TD>" & RecSet("Name") & "</TD>"
Response.Write"<TD>" & RecSet("Occupation") & "</TD></TR>"
RecSet.MoveNext
Loop
Response.Write"</TABLE>"
%>
Thanks. I'm such a newbie that anything is a help!