This is a simple generic wrapper class to quickly general ADODB Connection strings, including password protected files & shaped recordsets. I've only needed support for Jet & xbase files so that's all I've included. Please feel free to expand and post them as long as I get a copy of any changes.
Inputs
Jet4: Database file
xbase: Data Directory
Returns
ADODB Connection String