Problem with Memo field in SELECT DISTINCT queries
Hello,
with sp2 for win2000 you installed Jet 4.0 sp5. You can use these queries
only with Jet 4.0 sp3 (win 2000 without sp).
If you install any sp for win 2000, you have to redesign all queries using
distict with Memo, Ole, Hypelink.
regards
Ryszard Gawron
Quote:
> I have an application developed with MDAC 2.5 sp1 using ADO with an
Access2K
> backend. It has worked fine until I installed it on a machine running
Win2K
> sp2. Now I get an error message "Cannot include Memo, OLE, or Hyperlink
> Object when you select unique values." Now do I have to re-write the SQL
> queries without the DISTINCT or Memo field just to run on Win2K sp2? Is
> this a bug with Win2K sp2 and MDAC 2.5 sp2? This seems like a problem if
a
> service pack "breaks" an application. Does anyone have any ideas about a
> fix? Thanks for your help.
> --
> Lynn Bills
