you have to use JDBC-ODBC. simply select "Microsoft Access" driver NOT "ODBC Socket" when you create your data source.
and the trick is to supply the following Database File = c:\test\xxxxx.mdb System Database File = c:\test\Security.mdw Use Default User name = true (checked) open show advanced settings : Default User name = a valid user Default password = a valid user password done . Regards Bob ________________________________ From: Jeanmarie Richardson <jean...@tdai.net> To: cf-talk <cf-talk@houseoffusion.com> Sent: Friday, August 28, 2009 3:20:43 AM Subject: How to make ODBC Connection to Access DB with MDW Connection Hi -- I need to make an ODBC connection to an access database that utilizes an MBW file for security. How can this be done? Could I use a connection string? Or does the ODBC manager allow this. Thanks in advance! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4