error '80020009' , does anyone what error is this???

[scriptblur]

Hi there, can anyone help me with this error... i kept getting it when i change whatever i can...
Can anyone help me to look at it? thank...

error '80020009'
Exception occurred.




:(

[whammy]

That looks like a fairly simple script - one thing you might want to try is changing the variable "Password" - if I recall, that's a reserved word in Access.

[scriptblur]

hi guys... thank for those who downloaded the files attached by me and wanted to help me... especially Whammy :)

i have found a solution....

[whammy]

What was the solution?

[scriptblur]

i have forgotten to bring the actual codes home and i think
the solution should be like this:

if rs.EOF then
Respnose.Redirect"Invalid_login.asp"
else
if rs("CategoryID")=1 then
Response.Redirect "content.htm"
else
rs("CategoryID") = 2 then
Response.Redirect "index.htm"

end if
end if

[dfrancis]

Originally posted by scriptblur
i have forgotten to bring the actual codes home and i think
the solution should be like this:

if rs.EOF then
Respnose .Redirect"Invalid_login.asp"
else
if rs("CategoryID")=1 then
Response.Redirect "content.htm"
else
rs("CategoryID") = 2 then
Response.Redirect "index.htm"

end if
end if

Respnose will cause a little heartburn too... :eek: