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: 126.96.36.199
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 188.8.131.52 thru 184.108.40.206 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 220.127.116.11 and all future releases. We reverted to using Microsoft JET.
If you upgrade to the latest 13.10 release (18.104.22.168 or 22.214.171.124) 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.