Error message

[jon98548]

I have a database that links to tables in other databases. I then pull that data together with a union query. This all works fine on my machine and on another machine in our group, but on the machine it really needs to run from, I get the following error message:

Cannot use Memo, OLE, or Hyperlink Object field 'Finding' in the SELECT clause of a union query.

I'm assuming there are some basic setup issues with Access on this desktop, but can't find it. Any ideas?

 

[jon98548]

I checked the references on my machine and the other machine and they both have the same thing installed.

 

[jon98548]

Pat, I have done some searching and made some changes which started something else. I appreciate your help as usual. If you want the follow up: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52734