Forum Discussion
tristaanogre
7 years agoEsteemed Contributor
The Jet Database engine only allows a set number of open connections. So, if during your test run you're exceeding those connections (and they aren't all to the same database or file, but in total), you might get this error. Basically, once you've opened a connection, you need to make sure that, as soon as you've obtained the necessary data, you close the connection. Using the DDT.ExcelDriver object, this is done by using the DDT.CloseDriver method.
How are you actually opening your connection to the excel spreadsheets? What does your code look like?
Related Content
- 12 years agomaheshwari_a
- 12 years agokirk_bottomley
- 4 years agoPUM-Prodat-SQL
- 3 years agotjohn
Recent Discussions
- 2 days agojstaehlin