I'm pretty sure you can use the brackets around the column name in queries from Access tables also. Not so sure how far this fix would go though--updates to the tables, etc.?
If it were me, I'd require them to rework to avoid the reserved words. That's just plain bad practice. > It would not be hard to grep or wingrep which template or queries use the > wrong columns names and replace them with just a slight variation. SQL > Server does this nicely by putting square brackets around reserved word > columns. I am not sure that is Access compatible. e.i. [year] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
