I have a little project and one query takes data from two tables and appends
them via a UNION clause. This resultant result set is then displayed to
allow the user to scroll through. Now this has worked fine for the last year
or so until I moved to W2K and MDAC 2.6

Now it fails with the error saying 'Memo fields can not be in the select
cause of a union query'. Is this a new restriction?. There is a memo field
in the select clause but there has been for months without a problem.

Thanks