ADODB.Recordset error '800a0cb3'
Can someone please help me on figuring out adding/updating new records on an ACCESS Database please? Below is my code and the error message:
Error Message
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
Program Code
!--#include file="Connection.asp"-->
<%
Dim rsUsers
Set rsUsers = Server.CreateObject("ADODB.Recordset")
sqlString= "SELECT * FROM Member WHERE SSN =" & Request.Form("SSN") & ";"
rsUsers.Open sqlString, objConn
If rsUsers.EOF Then
rsUsers.AddNew
Else
rsUsers.Update
End If
%>
Include File Connection.asp
<%
Dim curDir
Dim objConn
curDir = Server.MapPath("db/HFPension.mdb")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curDir
%>
|