ODBC and Access in particular are pretty picky about who can see what in a database. It would appear that Role_A may not have rights sufficient to let the user see the tables and views. You didn't indicate what version of SQL Server is being used, but from 2005 forward, we typically find it necessary to associate a user's rights with a schema, and we typically make it dbo because we expect the users to need to update tables. If that need doesn't exist, you may want to define a more restricted schema that they belong to. I suspect if User A is given the db_datareader permission as a user owned schema things should work. A final question - has this worked in the past and suddenly stopped working, or has User A just been added?