The user can read any table of the DB through SSMS, but cannot through Access even though the ODBC linked tables are accessible to me through the Access database. From the user's machine in SSMS I can access anything with their loin, but I can't do anything through Access with her machine, even directly opening the tables or using the linked table manager.
how is the ODBC connection setup? Is it a User DSN or System DSN? Is it Integrated Windows Authentication or SQL Server Authentication?