Delete an open .mdb file

[Smartchap]

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

[Doogle]

It's fairly unusual to delete the entire Database. Are you sure that's what you want to do. I can understand wanting to DROP a Table (ie Remove it completely) and DELETE FROM a Table (removing all rows from a Table)

[Keithuk]

Before you can Kill this database you have to close the connection the .ldb means its being used.

[DataMiser]

That is a very odd request. You can not delete a file that is open and you can not open a database that does not exist.

You can delete the data from the table as mentioned by Doogle which will remove all the data from the table.