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

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