Having never tried making an Add-In and always having troubles creating a connection string, I decided to try to create a Connection String Builder Add-In. The attached project is what I came up with. When you compile it, it is added to your Add-In list. After calling it up and selecting the appropriate information, it places the connection string on clipboard, ready to be pasted into your code.