'SQL UPDATE Woes..' Thread RSS Feed

SQL UPDATE Woes..

Wed, 22 Mar 2006 04:23:12 -0700

This message was edited by aaronjones3593 at 2006-3-22 6:36:50

When I try the following code, I get an error saying that I must use an "updateable query":

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

Any reason for this ?

-( Aaron )-

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

Re: SQL UPDATE Woes..

Thu, 23 Mar 2006 00:07:21 -0700

: This message was edited by aaronjones3593 at 2006-3-22 6:36:50

: When I try the following code, I get an error saying that I must use an "updateable query":
:
:

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

:
: Any reason for this ?
:
: -( Aaron )-
:

try this

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

weaps

Re: SQL UPDATE Woes..

Thu, 23 Mar 2006 05:13:10 -0700

: : This message was edited by aaronjones3593 at 2006-3-22 6:36:50

: : When I try the following code, I get an error saying that I must use an "updateable query":
: :
: :

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

: :
: : 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"

Re: SQL UPDATE Woes..

Sun, 26 Mar 2006 21:27:29 -0700

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

Re: SQL UPDATE Woes..

Tue, 28 Mar 2006 00:56:57 -0700

: 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"

Re: SQL UPDATE Woes..

Thu, 20 Apr 2006 11:09:04 -0700

: This message was edited by aaronjones3593 at 2006-3-22 6:36:50

: When I try the following code, I get an error saying that I must use an "updateable query":
:
:

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

:
: 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.