I'm having a problem in deleting a record in Access database. The error that is thrown is:
No value given for one or more required parameters
What I'm tying to do is to find a record by a name and also delete the record by name instead of using the ID I just don't want to include the ID even on my database but even if I remove the ID field on my database the error still occures. Here is the code that I'm trying to use to delete the record.
cmdDelete.CommandText = "DELETE FROM just WHERE folder =test" & ";" cmdDelete.CommandType = CommandType.Text cmdDelete.Connection = cnnOLEDB cmdDelete.ExecuteNonQuery() MsgBox("Record deleted.") cmdDelete.Dispose() MsgBox("Enter the required values") cmdUpdate.Dispose()