S
Stella Wu
Help!
I get Access 2000 Error massage as below when I UNION two
SELECT [Facility Photo Front],[XXX]FROM XXXX clause:
"Cannot use Memo, OLE, or Hyperlink Object field'Facility
Photo Front' in the SELECT clause of a union query."
Our requirement is to get building information from 7
database that are separated by their region. Photo image
has to be included in the report.
I appriciate if anyone could give an answer.
Thank you very much!
More information provided as below:
7 database linked together without any problem when I
SELECT image (OLE object photo) from one linked DB.
Moreover, the text information succeeded in union
selection from those 7 database.
I get Access 2000 Error massage as below when I UNION two
SELECT [Facility Photo Front],[XXX]FROM XXXX clause:
"Cannot use Memo, OLE, or Hyperlink Object field'Facility
Photo Front' in the SELECT clause of a union query."
Our requirement is to get building information from 7
database that are separated by their region. Photo image
has to be included in the report.
I appriciate if anyone could give an answer.
Thank you very much!
More information provided as below:
7 database linked together without any problem when I
SELECT image (OLE object photo) from one linked DB.
Moreover, the text information succeeded in union
selection from those 7 database.