On Fri, Feb 26, 2010 at 2:01 PM, Andrew Scott wrote: > Have you tried talking to your hosting provider, and switch case sensitivity > off for your database?
That is not a per-database setting. Once you have it set to some setting and have clients on it, a hosting provider is committed and can not change it anymore. But why not do the conversion on the Access side before migrating to MySQL? In Access you can simply rename the tables to the case you use in your queries before you convert them. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
