OK, I think Sue may have deduced the problem.  It appears you are using Integrated Security, which means that each network login must be given permissions on a database in order to see it from Access.  And Access requires that each user have full read/write permissions for each table.  I have seen cases where restoring from a backup did not retain the user permissions.  Check the user permissions using SSMS and see what they look like - I suspect they don't have full access to the table objects in SQL Server.  I presume from the connect string that you are still using Access 2010.  It is possible that there was some change in SQL Server 2016 that changed the way permissions get set, but I'm not aware of any.