I've used code like this a lot
cFile="c:\temp\test.udl"
FilePut("",cFile)
which creates a .udl file that when opened pops up the Provider Menu which permits creating and testing a connection string. As of Office 2007, the ACE Provider is used in place of the Jet Provider. However, on a 64-bit system with 32bit Office installed, a .udl will not show the Ace Provider. However, this command will
C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\temp\test.udl
I tried to execute it from WB's RunShell(), but appear to be having a syntax hemorrhage.