Help with deleting an MSAccess file in VB6.0

[Siddharth Rout]

Sorry this was a vb6.0 app upgraded to net. I do not want to change the way the DB connections are made and such. So I want to stay with the formats I know a little better.

Try something like this... I typed this in notepad so please amend syntax errors if any...

Try
    oConnOleDb = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database1.mdb")
    oConnOleDb.Open()
    oCmdOleDb = New OleDbCommand("Delete from SDID1OrderDetail blah blah query",oConnOleDb)


    If (oCmdOleDb.ExecuteNonQuery > 0) Then
        MsgBox ("The Quote record has been deleted.")
    End If
Catch ex As Exception
    MsgBox(ex.Message.ToString(), MsgBoxStyle.Information)

Finally
    oConnOleDb.Close()
End Try