How to close ADO Data Control connection?
Posted on 2007-04-03
Within an Excel VBA application, I'm using the ADO Data Control to populate a DataGrid with data from an Access table.
I set the connection and recordsource properties on opening the file, then set them to empty strings on closing. However once my app. is closed there still exists an Access record-locking icon for the database in Explorer.
I don't seem to be able to close the database; the ADO Data Control doesn't have a connection.close method. How do I do it? It's even causing a fatal error on Windows shutdown.