Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 12 of 12
  1. #1
    New Coder
    Join Date
    Jun 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HELP ME please '80004005'

    i am getting this error when i try to login

    Microsoft JET Database Engine error '80004005'

    Operation must use an updateable query.

    /login.asp, line 44


    and this is what is on line 44

    MyConn.Execute(SQL)

    PLEASE help me asap thanx

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    whats in the variable SQL?

  • #3
    New Coder
    Join Date
    Jun 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    here is line 30 to line 57


    While Not RS.EOF
    If UserName = RS("Username") And Password = RS("Password") Then
    Session("allow") = True
    Session("clearance") = RS("Clearance")
    Level = RS("Clearance")
    End If
    RS.MoveNext
    Wend

    If Session("allow") = True Then

    vip = Request.ServerVariables("REMOTE_ADDR")

    SQL = "UPDATE Members Set IP = '" & vip & "' WHERE Username = '" & UserName & "'"
    MyConn.Execute(SQL)


    If Level = 0 Then Response.Redirect "error/inactive.asp"
    If Level = 1 Then Response.Redirect "news.asp"
    If Level = 2 Then Response.Redirect "news.asp"
    If Level = 3 Then Response.Redirect "news.asp"
    If Level = 4 Then Response.Redirect "news.asp"
    If Level = 5 Then Response.Redirect "news.asp"
    If Level = 50 Then Response.Redirect "news.asp"
    If Level = 99 Then Response.Redirect "error/multies.asp"
    If Level = 100 Then Response.Redirect "error/security.asp"

  • #4
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    The error message:

    Operation must use an updateable query

    means either:

    1 - your db is in a folder that does not have write permissions.

    Check with your server admin

    2 - you have a recordset that has been opened as read-only.

    Opening an updatable Recordset

  • #5
    New Coder
    Join Date
    Jun 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ok i read it but i dont realy understand a example of that recordset thing would be nice i am farly new to asp and .mdb and all this stuff PLEASE help me thanx

  • #6
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Like ReyN said, that sounds to me like the folder your database is residing in doesn't have write permissions. (That's usually the reason for that error, anyway - also like ReyN said, you might have it opened as read-only.)

    Either way, it means you can't write to it the way things are. Can you include your connection string as well?

    P.S. Who's your host? If it happens to be brinkster.com and your Access database isn't in the database folder, you will get that very error - that's the only directory with write permissions.
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #7
    New Coder
    Join Date
    Jun 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    my host is gnxonline

  • #8
    Senior Coder Morgoth's Avatar
    Join Date
    Jun 2002
    Location
    Ontario, Canada Remaining Brain Cells: 6
    Posts
    1,402
    Thanks
    2
    Thanked 1 Time in 1 Post

    Personal Question:

    Hum...

    SQL = "UPDATE Members Set IP = '" & vip & "' WHERE Username = '" & UserName & "'"

    "Members Set IP"
    Why is the set in there?

  • #9
    New Coder
    Join Date
    Jun 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have no clue why that is there i will try and take it out and see what happens

  • #10
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Actually that's the correct syntax for an UPDATE statement. I don't see anything wrong with that...
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #11
    Senior Coder Morgoth's Avatar
    Join Date
    Jun 2002
    Location
    Ontario, Canada Remaining Brain Cells: 6
    Posts
    1,402
    Thanks
    2
    Thanked 1 Time in 1 Post
    I just tested it, yeah, set is supose to be there, it just doesn't look right if you don't cap it:

    SQL = "UPDATE members SET ip = '" & vip & "' WHERE username = '" & username & "'"

  • #12
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    OK... it seems to be clear that the69pimp needs to talk to his host in order to resolve this problem .

    I'm going to close this thread. the69pimp, if you still need help with this, or if you feel that I closed this thread in error, feel free to email me.

    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •