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"

: 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

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

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"

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