Coldfusion MX 7.0 with 'Access with Unicode'

[IVO2003]

I used to use Coldfusion 5 with Access DB (Using ODBC DSN) under IIS,
everything works fine. Now I upgraded Coldfusion 5 to Coldfusion MX 7.0 with DB
'Access with Unicode'. <cfinsert > tag can not insert long text anymore. If
user inputs long text in 'Description' Textarea, CFINSERT reports an error.
'Description' uses MEMO type in access DB. Please help! Error Message:
Error Executing Database Query. The error occurred in
C:\Inetpub\wwwroot\sample\InsertMessage.cfm: line 37 35 : <cftransaction> 36
: <CFINSERT DATASOURCE='MyDB' TABLENAME='Messages' 37 :
FormFields='SiteID,Subject,Description'>
--------------------------------------------------------------------------------
SQL insert into Messages(SiteID,Subject,Description) values ( (param 1) ,
(param 2) , (param 3) )

[BenForta]

Did you try the Access driver (instead of Access with Unicode)?

[IVO2003]

CFInsert can insert long text in Access DB, however, since this site contains
some chinese, it could NOT show chinese with Access, it could not show chinese
with ODBC Socket either in coldfusion mx 7.0. It only works with access with
Unicode, however, Access with Unicode: 1. CFINSERT could not insert long text.
2. DB field name could not be 'password', seems 'password' is the key word
reserved in coldfusion mx 7.0. Thanks.