This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 9%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
i have an MS Access client with linked tables from SQL Server 2019. All users of the app have the same rights to the tables - adding/editing records.
The first time a user tries to open a form bound to a linked table, SQL Server login pops up displaying the DSN and login ID, and prompts for a password.
The issue is that i don't want this to happen. i don't want the users to even know the login credentials. i just want the application to login automatically to SQL Server and display the data on the form. How can i do this? If i have to use VBA, can someone post the code i need to use?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
When you create the new data source to SQL server be sure to use an sql user (don't use integrated windows authentication) By using an sql user and check the box for Save Password then the credentials will be saved within Connect field of MSysObjects table in access.
--please don't forget to upvote and Accept as answer if the reply is helpful--
Thank you very much @Anonymous . It took me a while to discover that the Save Password checkbox was on the screen where the tables to be linked are selected. i'm glad it occurred to me to look for a forum like this to pose my question after several hours of trying on my own to figure out a solution. You made my day!
Glad to hear, you're welcome.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)