In vb6 I am using Microsoft.Jet.OLEDB.4.0 to open an existing .mdb file. Before opening it I want to Kill (delete) it so that new data is inserted in it.
When first time it is opened, Kill statement deletes the file and new data appears in Report but when next time Kill is used, it doesn't delete the file (as .ldb file is made this time).
Please help me delete this .mdb file in this case.

Thanks