I'm getting this error running a select stmt that sums thousands of records. I think it may be a timing issue but I'm sure I've run larger queries.
ADODB.Connection error '800a0e80'
Operation has been cancelled by the user.
I can't find info on this error anywhere. Has anyone seen it , or have an idea where to look or how to troubleshoot?
My select is ...
strsql = "SELECT Fund, SUM(Shares) AS TotalShares, SUM(Cost) AS TotalCost
WHERE PlanMne ='" & Session("PlanMne") & "' "
GROUP BY Fund
ORDER BY Fund
I'm using the Advantage database from Extended Systems if that matters.