I've received that message on occasion as well. It has happened when I created a query through Enterprise Manager and then for whatever reason, ran it in Access. I can't remember what type of join it fails on. If you can, re-create the query in Access through the query design wizard and see how Access creates the same query. That might give you better insight on which types of joins Access doesn't like.
Mark -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 11:04 AM To: CF-Talk Subject: OT: weird msg on sql to access change I have a development and production server. The only difference between them is the datasource- the production uses sql and the development has an access db. Well I have a query that works fine on the SQL server but conks out on the access one....I'm getting the message that the join expression not supported. Does this mean simply that the query is too complicated for ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
