From Access, can see some BUT not all tables in AWS RDS SQL Server schema

Copper Contributor

From our Houston office, created Access front-end using linked tables from AWS RDS SQL Server and placed it out on our network and setup ODBC DSN for users accross Houston and Calgary offices....users in Houston Office have no problem, but users in Calgary Office are seeing ODBC errors associated with about half of the linked tables...within a Teams call, I took control of one of the Calgary users desktop and attempted to reattach the linked tables, but when I went under ExternalData/NewDataSource, I can only see about half the tables in the RDS database. 


All tables reside in exact same RDS database and schema (dbo).


Anyone got a clue as to what is going on?  

2 Replies
And the DSN is using the admin username and it is not a permission issue.