ADO DataControl Connection

[Asterisk]

I have an ADO DataControl which i at runtime connect to a database by using the ConnectionString and RecordSource properties. But what i now need to do is disconnect the control from the database so that i can delete the database. I know how to do this using the ADO objects but have not been able to do the same thing with the datacontrol. Is it possible ?

Thanks

[Clunietp]

This works fine for me

    Dim strDBName As String
    
    strDBName = "F:\Nwind2k.mdb"
    
    'open db
    With Me.Adodc1
        
        .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBName
        .RecordSource = "Select * from Customers"
        .Refresh
        
        .Recordset.Requery

        'we have a value
        MsgBox .Recordset(0)
        

        'close
        
        .Recordset.Close
        Set .Recordset = Nothing
        .ConnectionString = ""
        .RecordSource = ""
        
        'kill db
        Kill strDBName
    End With

[Asterisk]

Thanks, I'll give it a try