Forum Discussion

Copper Contributor

Apr 27, 2020

Compatibility with Amazon Redshift as external database

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 ...

access

jussi58

Copper Contributor

Apr 28, 2020

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

tsgiannis

Iron Contributor

Apr 29, 2020

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

jussi58
Copper Contributor
May 01, 2020
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.