In my opinion, it would have been good if this had been continued in the thread where it was begun; that would have made it so that your statements had a context. Saying in this thread that you fixed something means nothing to those who don't know what you fixed...
For those coming to this new, the original is in
http://p2p.wrox.com/topic.asp?TOPIC_ID=49965
____________________ _
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ¯
Perhaps your query is trying to translate the field name as a keyword.
What happens if you use
Code:
Private Sub cmdUpdate_Click(ByVal sdr As System.Object, _
ByVal e As System.EventArgs) _
Handles cmdUpdate.Click
Dim intPosition As Int16
intPosition = myCurrencyManager.Position
myCommand = New OleDbCommand
myCommand.CommandText = "UPDATE login " & _
"SET login.Password = @Password " & _
"WHERE UserId = @UserId "
or
Code:
Private Sub cmdUpdate_Click(ByVal sdr As System.Object, _
Code:
ByVal e As System.EventArgs) _
Handles cmdUpdate.Click
Dim intPosition As Int16
intPosition = myCurrencyManager.Position
myCommand = New OleDbCommand
myCommand.CommandText = "UPDATE login " & _
"SET [login].[Password] = @Password " & _
"WHERE [login].[UserId] = @UserId "
?