• Access does not have linked tables with windows authentication.

    If I am correct, Access will link to SQL server using one SQL Server login where the credentials are stored when the tables are linked. This way all the users of Access will look the same. Access has the ability to generate user level security. Access will then control who gets to update which table. Access does not care where the data resides. It can be in another Access database, a SharePoint List or in an SQL Server Database.

    based upon the above, I need to do nothing more than link delete the tables in Access and link them to SQL Server. Right?