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

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