Is This Content Helpful?
We're glad to know this article was helpful.
Closing and subsequently reopening an ADO connection (in VBA or VB) sometimes fails with the following error:
"Provider not found. It may not be properly installed."
Provider has not been referenced prior to reopening.
Include the following line of code before you reopen the ADO connection:
<ADO connection object>.provider = <name of provider>