Display the ADO Connection Window (ADO DB Designer)

Category:
Database
Type:
Snippets
Difficulty:
Intermediate
Author:
Leo Koach

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
This function takes a connection string as a parameter and displays the ADO DB Designer Window, which allows the user to edit the properties of the connection. It returns the modified connection string, per the user's selections. References to Microsoft Active Data Objects and the the Microsoft OLE DB Service Component 1.0 Type Library are required.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: