Is there an example to post asp results into an ACESS Table

D

Dave

I am trying to get my form results posted into a table. I get the message
the information was submitted, but there is not anyhting in the table.

My Database = C:\MyDatabses\database.mdb
My Table = Results
The Results Table fields = last_name_field and first_name_field

I know I am close - can anyone help

Thanks

Dave

<html>

<head>
<%
'---------------------------------------------
'Set the connection to the database
strConn = "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:\MyDatabases\database.mdb;DefaultDir=;UID=;PWD=;"
Set connection = Server.CreateObject("ADODB.Connection")
connection.Open strConn
'---------------------------------------------
'Open a specific table and assign the recordset
Set accessRS = Server.CreateObject("ADODB.RECORDSET")
sql_stmt = "SELECT * FROM [myTable]"
accessRS.Open sql_stmt, connection, 1, 2
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

If Not accessRS.EOF Then
accessRS.MoveFirst
accessRS.Fields("last_name_field") = Request.Form("ELast")
accessRS.Fields("first_name_field") = Request.Form("EFast")
accessRS.Update
End If

%>
</head>

<body>
<p><font face="Arial" size="2">Your information has been submitted.</font>
</p>
</body>

</html>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Multiple Records into a table with one form 3
Operation must use an updateable query. 2
Force results to print on separate pages 1
Operation must use an updateable query. 2
File upload into database doesn't work 2
Access Database record added via asp - but it is not inserted 3
ASP Error 2
Problem with an .asp page displaying data based on a form field value. 5

Top