SQL UPDATE Woes.. - Programmers Heaven

Howdy, Stranger!

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

Categories

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

  • weapon__xweapon__x Posts: 138Member
    : [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

  • aaronjones3593aaronjones3593 Posts: 122Member
    : : [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"

  • weapon__xweapon__x Posts: 138Member
    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

  • aaronjones3593aaronjones3593 Posts: 122Member
    : 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"

  • ManningManning Posts: 1,621Member
    : [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.