Member Avatar for TeresaTa

Hello anybody
I am trying to update table to access database in vb.net after changing password.
But I have a problem in update error as following

Dim dbCommmand As New System.Data.OleDb.OleDbCommand
        Dim DBConnection As New System.Data.OleDb.OleDbConnection       
        DBConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\thaeaye\Documents\Testing.mdb"      
        dbCommmand.CommandType = CommandType.Text
        dbCommmand.Connection = DBConnection
        DBConnection.Open()
        dbCommmand.CommandText = ("UPDATE PasswordEntry SET Password='" & DatabasePasswordLogInPassword & "' WHERE AccessName = '" & PasswordMode & "';")
              
      
        dbCommmand.ExecuteNonQuery()
        DBConnection.Close()
       
        MsgBox("The New Password Was successfuly Changed.", vbOKOnly, "Password Change")
Edited by TeresaTa because: n/a
  • 3 Contributors
  • 3 Replies
  • 93 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by GeekByChoiCe
Member Avatar for Netcode

You did not say what the error was but please check your UPDATE Statement and check what the semicolon (;) would or should be doing there

Member Avatar for TeresaTa

I just started learning about database. Syntax in database command are confusing for me. In this case the error is not because of semicolon. If I write the code following, it is working. No matter what I am very thankful to you.

dbCommmand.CommandText = ("UPDATE PasswordEntry SET [Password]='" & DatabasePasswordLogInPassword & "' WHERE AccessName = '" & PasswordMode & "';")
Member Avatar for GeekByChoiCe

put a TryCatch block around your Update function and see what the exact error is.
"not working" is not a valid error description and we are not able to help you then.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.