Are you sure that is the reason? What does your code look like? In the meantime, here is some code to connect to an Access database, reterive data from Table1, close the recordset and close the connection using Visual Basic with ADO:
Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!