Add or Update data into the database

d1004 · Oct 16, 2002

I tried to add the password that the users setup into the database. Basically, they entered their Alias, now
they have an opportunity to setup their password. This is the code that I have... But somehow it gives me
the following error message when I run it:

Error = "Operation must use an updateable query"

Here are my codes:

<%
Option Explicit
Dim strConnect
%>

<html>
<head>
<title> Add User's Password Info </title>
</head>
<body>
<%
Dim objRS, objConn,

strConnect = "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("Login.mdb&quot

&";" & _
"Persist Security Info = False"

Set objConn = Server.CreateObject("ADODB.Connection&quot

Set objRS = Server.CreateObject("ADODB.Recordset&quot

objConn.open strConnect

objRS.Open "tblLoginInfo", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable

objRS.Filter = "Alias = '" & Session("Alias&quot

& "'"

objRS("Password&quot

= Request.QueryString("PWord&quot

objRS.Update

objRS.Close
objConn.Close
Set objRS = Nothing
Set objConn = Nothing
Response.Redirect "menu.asp"

%>

</body>
</html>

I don't know what I am doing wrong, please help!!!
-d1004

MrGreed · Oct 16, 2002

You might want to check this link out, it might help you out.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadoapireference.asp

"did you just say Minkey?, yes that's what I said."

MrGreed

Chopsaki · Oct 16, 2002

$5 says that the IIS user doesn't have write permissions to the directory that the access db is in. You need to give write permissions if you want to update it. foo

d1004 · Oct 17, 2002

Chopsaki,
Hehehe, you won that $5
MrGreed,
The website was great, thanks again!!!
Thank you!!!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Add or Update data into the database

d1004

Programmer

MrGreed

Programmer

Chopsaki

Programmer

d1004

Programmer

Similar threads

Part and Inventory Search

Sponsor