Hi Stephen, Cheers for that - one of the va fields was memo. Was an error, but that should have been picked up on our dev server - not sure why it works on dev server but not live. Anyway, have referenced the fields by name now, rather than * and all okay. Bizarre.
Many thanks for the heads up, Ross -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 11:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Weird Access Error > ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or > Hyperlink Object when you select unique values (va_description). > [snip] > Is that error prototypical of anything in particular? > Its just what it says it is....... You cannot include a Memo field in the DISTINCT query. At a guess I was say that one of the fields in va.* is a memo field. Regards Stephen. PS. Prototypical is too long a word for a monday morning! -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
