Using SELECT DISTINCT (when memo fields are involved)

[paty]

I am developing a database and one of my queries uses the DISTINCT keyword. Some of the fields that I am selecting are memo fields. While trying to run the query, some of the users are getting "RUNTIME ERROR 3114", which indicates that you cannot select distinct values when memo fields are part of the selection. HOWEVER, some of the PC's are able to run this query without a problem. Does anyone know why this error is PC specific? The Operating system does not seem to be the common thread. We are all using Office 2000.

 

[tlbroadbent]

Are you certain that some PCs can run the query? Access will not sort on a memo field and sorting is required to Select Distinct. If you select part of the memo (i.e., Left(MemoCol, 128)) then Access should be able to sort and Select Distinct. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[paty]

Thanks for responding.
Yes, I am absolutely certain that some PC's can handle it. Mine handles it just fine (I know, this is odd). There are two computers with (I think) Windows NT that are getting the error. The rest of them do not get an error and "seem" to run the query just fine. I know that I am getting memo fields on those results but have not made sure that they are not truncated or have other problems. At first, I thought that the two NT computers were the ones with the problem. At this time, after reading more on the subject, I am more than anything curious as to why, if the error is by design, most PC's here are not getting it. I should mention that there is one other PC with Windows NT that is NOT getting the error.