Windows 7 SP1 breaks ADODB

If you are using ADO in you Access database be aware of Breaking change in MDAC ADODB COM components in Windows 7 Service Pack 1 and "Type Mismatch" error message when you run a VBA macro in a 64-bit version of an Office 2010 application