Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

distinct calause query fails to run for memo field

Status
Not open for further replies.

asimasm

Programmer
Nov 27, 2000
62
AU
hi
i had created a query from a table that contains memo fields. now if i run simple query like
SELECT DISTINCT memo_f1,memo_f2,memo_f3 from TblXYZ
then the query executes perfectly fine on some Computers and fails to run on others and gives the following error message:

" Cannot include Memo, OLE, Hyperlink Object when you select Unique Values (TblXYZ.memo_f1) "


i cant figure out what exactly the problem is. Actually i am using this query in my application and it would fail to execute on some client machines. Can any one tell me which dlls or components are required so that i may include them in my setup package.
 
Hi,

Have you got the latest service packs for Access, jet and MDAC? If then get them and retry it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top