I built an Access 2016 Forms front-end where the tables are linked from an SQL Server back-end on a different machine; it works well.
I have multiple users with different permissions on the tables set up in the back-end. The issue is that Access is not requiring that a user/pwd be entered; i.e.: once the connection is established, Access just uses it without requiring a pwd.
What I'd *like* to get is where the front-end (Access) user supplies a back-end (SQL Server) user name/pwd. I have researched file-based links, user-based links, and machine-based links. User-based looks to be most promising; however, I think that's the *Windows* user and I'd like to authenticate the link at the SQL Server.
Steven Smith (Usually an Oracle user)