Try http://search.microsoft.com/us/dev/default.asp as I did.

>>Union can go against nothing. What if you use UNION ALL?
>>Never met this ODBC error. Try to search MSDN Library for exact phrase "Error in assignment". It returned 10 articles for me.
>
>I looked on our January MSDN disks and got no help at all. This is a real puzzle, but ever since I started working with ODBC to access I have run across this kind of stuff.