SQL UPDATE Woes..

[b][red]This message was edited by aaronjones3593 at 2006-3-22 6:36:50[/red][/b][hr]
When I try the following code, I get an error saying that I must use an "updateable query":

[code]
objConn.Open "DSN1"
objRs.Open "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator'", objConn
[/code]

Any reason for this ?

-( Aaron )-

"Alcohol aint the answer, but atleast you forget the question"


Comments

  • : [b][red]This message was edited by aaronjones3593 at 2006-3-22 6:36:50[/red][/b][hr]
    : When I try the following code, I get an error saying that I must use an "updateable query":
    :
    : [code]
    : objConn.Open "DSN1"
    : objRs.Open "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator'", objConn
    : [/code]
    :
    : Any reason for this ?
    :
    : -( Aaron )-
    :


    try this

    objConn.Open "DSN1"
    objConn. Execute "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator';"
    baboy... baboy...

    weaps

  • : : [b][red]This message was edited by aaronjones3593 at 2006-3-22 6:36:50[/red][/b][hr]
    : : When I try the following code, I get an error saying that I must use an "updateable query":
    : :
    : : [code]
    : : objConn.Open "DSN1"
    : : objRs.Open "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator'", objConn
    : : [/code]
    : :
    : : Any reason for this ?
    : :
    : : -( Aaron )-
    : :
    :
    :
    : try this
    :
    : objConn.Open "DSN1"
    : objConn. Execute "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator';"
    : baboy... baboy...
    :
    : weaps
    :
    :

    Already tried that approach before posting the problem, sorry...



    -( Aaron )-

    "Alcohol aint the answer, but atleast you forget the question"

  • objConn.Open "DSN1"
    objConn. Execute "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator';"

    you may want to try==>>
    objConn.Open "DSN1"
    objConn. Execute "UPDATE Members SET Members.Username = 'Admin1' WHERE Members.Username = 'Administrator';"


    baboy... baboy...

    weaps

  • : objConn.Open "DSN1"
    : objConn. Execute "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator';"
    :
    : you may want to try==>>
    : objConn.Open "DSN1"
    : objConn. Execute "UPDATE Members SET Members.Username = 'Admin1' WHERE Members.Username = 'Administrator';"
    :
    :
    : baboy... baboy...
    :
    : weaps
    :
    :

    nope... :'(



    -( Aaron )-

    "Alcohol aint the answer, but atleast you forget the question"

  • : [b][red]This message was edited by aaronjones3593 at 2006-3-22 6:36:50[/red][/b][hr]
    : When I try the following code, I get an error saying that I must use an "updateable query":
    :
    : [code]
    : objConn.Open "DSN1"
    : objRs.Open "UPDATE [Members] SET [Username] = 'Admin1' WHERE [Username] = 'Administrator'", objConn
    : [/code]
    :
    : Any reason for this ?


    What is your data source? If it's an Access database, you need to make sure the IUSR_MachineName account has write access to the database. If you search on Google, you should find lots of information about the problem.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories