File handling and open databases

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?

Welcome to VBForums :wave:

I'm not sure (as I don't use Data Controls), but I don't think you can close it.

If you were using the 'proper' method of ADO code (as in the ADO Tutorial link in my signature) it would just take two simple lines of code.