Obviously, if all users look the same in SQL Server, there is not much you can do.

Then again, why would you not be able to set up the linked tables with Windows authentication? In that case, each user is distinct in SQL Server.

Full disclosure: I know nothing about Access.