HELP!! Operation must use an updateable query, but its not permissions!!

Hello,

Im at the start of creating an intranet, and am trying to create the login page but I keep getting the following message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/_vti_script/Login/html/new.asp, line 15


It seems to be having a problem with this line:
conn.Execute "insert into tblLogin (Name, EmailAddress, Password) values (" _

If you can make it out, my code is as follows:

set RSLogin = conn.Execute("select LoginID, Name from tblLogin where " _
& "EmailAddress = '" & Request.Form("EmailAddress") & "' and " _
& "Password = '" & Request.Form("Password") & "'")
if RSLogin.EOF then
conn.Execute "insert into tblLogin (Name, EmailAddress, Password) values (" _
& "'" & Request.Form("Name") & "', " _
& "'" & Request.Form("EmailAddress") & "', " _
& "'" & Request.Form("Password") & "')"
set RSLogin = conn.Execute("select LoginID from tblLogin where " _
& "EmailAddress = '" & Request.Form("EmailAddress") & "' and " _
& "Password = '" & Request.Form("Password") & "'")



Ive tried sorting out the permissions but that hasnt helped
Id really really really appreciate it if someone could tell me what to do.


Thanks in advance

My guess is you didn't open the connection in the correct mode, since you aren't calling the open method, just the execute.

Solution

hello, I really appreciate ur quick reply,
I tried doin that, so my code is now as follows:

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Mode = 3
Conn.Open "DSN=intrepid;UID=Admin;PWD=ic"

set RSLogin = conn.Execute("select LoginID, Name from tblLogin where " _
& "EmailAddress = '" & Request.Form("EmailAddress") & "' and " _
& "Password = '" & Request.Form("Password") & "'")

but it still doesnt work

If ive done it wrong, or if you have any other suggestions please let me know

Thanks so much

hi,
I ran into this once before ... i CHANGED the security and i continued to get the godforesaken message "Operation must use an updateable query." I eventually rebooted my server out of frustration .... and ... whaddaya know!!! - It worked!

IT WORKED!!

YOUR A STAR!!!!

THANK U SOO MUCH

no problem