<div>
Do not use the ADODC to start with. Ther eis no reason for you to do so. &nbsp;Instead use ADO directyl<br />
<br />
Dim conn As ADODB.Connection<br />
Dim rs As ADODB.Recordset<br />
<br />
and so on. Once you create the recordset you bind it to the DataGrid. &nbsp;At the end:<br />
<br />
rs.Close<br />
Set rs = Nothing<br />
<br />
conn.Close<br />
Set conn = Nothing<br />
<br />
Leon<br />

</div>


Do not use the ADODC to start with. Ther eis no reason for you to do so.  Instead use ADO directyl

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset

and so on. Once you create the recordset you bind it to the DataGrid.  At the end:

rs.Close
Set rs = Nothing

conn.Close
Set conn = Nothing

Leon


<div>
How do I bind the DataGrid to the recordset?
</div>


How do I bind the DataGrid to the recordset?

<div>
<div class="content wysiwyg-content">
Within an Excel VBA application, I'm using the ADO Data Control to populate a DataGrid with data from an Access table.<br />
<br />
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.<br />
<br />
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? &nbsp;It's even causing a fatal error on Windows shutdown.
</div>
</div>


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.

How to close ADO Data Control connection?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.