> OK, could you try this before we resort to more drastic things. When
> you are looking at the design view of your query, right click and call
> up "properties" or call it up under the "View" menu. For the "RecordSet
> type" property, try changing it to "Snapshot". See if this causes
> Access to not throw the "order by" clause in the query.
> Of course having the recordset type as a snapshot means you can't update
> the query resultset. Let me know if it works.
Bruce Tong | Got me an office; I'm there late at night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century
In response to
pgsql-interfaces by date
|Next:||From: Byron Nikolaidis||Date: 1998-07-23 17:30:42|
|Subject: Re: [HACKERS] ODBC and palloc ...|
|Previous:||From: Jackson, DeJuan||Date: 1998-07-23 16:17:16|
|Subject: RE: [GENERAL] ODBC Driver|
pgsql-general by date
|Next:||From: Steve Doliov||Date: 1998-07-23 17:35:39|
|Subject: Re: [GENERAL] Re: [MIRRORS] Revamp'd Web Site...|
|Previous:||From: Lorenzo Huerta||Date: 1998-07-23 16:55:53|
|Subject: help with uniq index|