I am getting "Run-time error '-2147287038'(80030002)" when the code getting to populating the recordset. I can always fall back on embedded SQL, but want to introduce my team to faster techniques.
What I thought of trying was to open the connection, the use QueryTable.Add to bypass the...