Thanks for the response. VB.Net
I've removed the actual query strings in strSQL as they are long but work well.
I'm using access to run the query because my queries contain user defined functions and as far as I know, that is the only way to use them in the query.
And yes, my error trap is very...