Whenever I try to export my dataset from SQLA 13.10.0.04 into an MS Access 2007 table I get the following error:
SQLA Version: 220.127.116.11
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Access.Dao.Recordset'.
Any ideas how this can be rectified?
Versions 18.104.22.168 thru 22.214.171.124 used the Microsoft Office Access Engine dll to support the Export to Access function.
Unfortunately Microsoft designed that dll in such a way that only one version can exist on your system. That means that if you install certain versions of Microsoft Office then that feature will fail.
Because of this we stopped using that dll in 126.96.36.199 and all future releases. We reverted to using Microsoft JET.
If you upgrade to the latest 13.10 release (188.8.131.52 or 184.108.40.206) you will be able to export to Access 2003 (*.mdb) files - but not Access 2007 (*.accdb) files. Microsoft Access 2007 and 2010 can however open Access 2003 files.