English

Problem: Reopening an existing ADO connection in VBA or VB

Description

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."

Cause

Provider has not been referenced prior to reopening.

Solution or Workaround

Include the following line of code before you reopen the ADO connection:

Code:
<ADO connection object>.provider = <name of provider>