We connect MsAccess 2016 on Windows 7 64 bit, to Teradata using ODBC connection for Teradata.
For querying purpose we use pass through Sql. However, MsAccess is not able to quickly consume the rows returned by Teradata that is causing performance issues.
To further clarify, when we execute pass through query, Teradata would execute the same and send results(Aroud 2 Million rows) to MsAccess in 40 seconds flat. But MsAccess is not able to quickly consume those rows and display the results.
Any suggestions, how we can make MsAccess to respond quickly.
Between we have tried creating the internal tables on Msaccess and then query the same. But it does not help.