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 5 Years Ago by TeresaTa: n/a