Compatibility with Amazon Redshift as external database

Question

Is it possible to determine whether Access 2019 is compatible with the current version of Amazon Redshift as an external data source? Specifically, does the linked tables feature work with Redshift via ODBC?

PostgreSQL appears to work with Access, but not Redshift, although there are reports on the web of Redshift being used in this way.

We are able to connect to Redshift in Access (via ODBC), and we reach the point of seeing the list of tables in the database to select from. When we select any table, even a very simple table owned by the connecting user and containing an INTEGER primary key and other standard SQL data types, the following error appears:

Reserved error (-7733); there is no message for this error.

Thank you for any assistance.

tsgiannis · Answer

jussi58&nbsp;Take a look here :http://www.utteraccess.com/forum/lofiversion/index.php/t2032855.html

jussi58 · Answer

tsgiannis&nbsp;Thank you very much for finding this.&nbsp; It includes the suggestion of using passthrough as a workaround, which will not work in my case.&nbsp; But it looks like we have the same problem now that was reported in 2015.

tsgiannis · Answer

jussi58&nbsp;Can i ask why Pass through queries are not an option. ?

george hepworth · Answer

jussi58&nbsp;Have explored the AWS documentation and troubleshooting pages?

jussi58 · Answer

tsgiannisYes, this is for a data warehouse with more than 100 tables, and my (limited) understanding is that setting up passthrough queries would be laborious with that many tables.

Forum Discussion

Compatibility with Amazon Redshift as external database

Share

Resources