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?

 

[Pat Hartman]

The usual suspect in this situation (db works on some PC's but not others) is reference errors. Open any code module. Then go to Tools/References. You may see the word "MISSING". If so, that indicates the missing library. Search the archives for how to resolve these problems.

 

[jon98548]

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

 

[Pat Hartman]

Did you read any of the other posts on this topic? Sometimes it is simply a matter of selecting a new library to force Access to refresh the library collection.

 

[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