So what can I do to sort in Access '97? I doubt the backend will
be getting changed anytime soon.
---
Chris Osborn, Network Administrator T3West/WebCow!
707 255 9330 x225 - Voice 1804 Soscol Ave, #203
707 224 9916 - Fax Napa, CA 94559
<fozztexx@t3west.com> <http://t3west.com/>
On May. 09 98, 17:12 PDT, "Byron Nikolaidis" <byronn@insightdist.com>
wrote:
> Access insists on using order by clauses like that, even though
> the driver returns information saying it can't support it!
> Postgres simply can't handle order by clauses without the fields
> also being in the target.
> The error you see is a legitimate error coming from the backend.
> When the backend can handle those kinds of order by clauses, the
> error will stop happening.