Another thought: are you using MX? I've recently had a problem with Access on MX: by default the DB Driver does not accept "long text". There's a check box in the CF Admin Data Sources area - if you ARE using MX and the box isn't checked CF (actually the DB driver) may be truncating your insert value.
In my case the problem was showing up in a select - any "memo" fields were being returned as having no values to CF even if there were values in the DB. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
