Let users Add/Edit records [ASP]
 

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!

I'm not up on the ASP object model, but scripts that allow users to insert and update database records almost always use an HTML form page to submit the user data. The server script gets the user data from query string or POST variables (available via ASP's Request object, I believe), opens a database connection, and uses the SQL INSERT or UPDATE statement in a query to store the data.

Thanks!! You've pretty much got the right idea, it seems. I did a little reading on some other sites and I saw HTML forms that were used with ASP pages to insert records.

I've got to tinker with this a bit and try to get a successful insert record thing going.

In the meantime, if anyone knows of a particularly helpful site or tutorial, that would be great!

Just about every Web application you can name uses that model. This message board, for example, stores members' posts in a MySQL database. Blogs, online stores, shopping carts, tag boards, and all that stuff work the same way.

This article should help you learn how to do most of what your looking for. Its a generic Access editor, but with any imagnation, you should be able to figure out how to apply it your your own needs.

http://www.4guysfromrolla.com/webtech/110999-1.shtml