Yes... seems those reserved words were a problem to always watch out for in Access.
-----Original Message----- From: Leigh [mailto:[email protected]] Sent: Friday, November 11, 2011 9:11 PM To: cf-talk Subject: Re: cfajax error Rick - The odbc date format should be fine. I am pretty sure the column named "Year" is the problem. It is a reserved word. -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

