Apologies if the answer to this is really simple, I want to use Kill to delete a database file (say C:\Database.mdb) but I have an ADODC that opens Database.mdb when the project loads.

The connection string is declared during design time, not runtime, how would I close the database in my code, to allow it to be deleted?