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?
