Article ID: 304536 - View products that this article applies to.
This article was previously published under Q304536
When opening and closing connections or recordsets using the Microsoft ODBC Driver for Access or the Microsoft OLE DB Provider for Jet, the following error may be reported:
After this error is reported, no more recordsets or connections can be opened from the same process.
Object invalid or no longer set.
Other possible error messages reported to the client application include:
Too many tables open.
Cannot open any more tables.
To resolve this problem, install the latest Microsoft Jet 4.0 service pack 6. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/239114/ )How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was fixed in Jet 4.0 Service Pack 6 (SP6).
To reproduce the problem, run the following Microsoft Visual Basic for Applications (VBA) code:
Article ID: 304536 - Last Review: September 26, 2005 - Revision: 2.3
Contact us for more help
Connect with Answer Desk for expert help.