<div>
<div class="content wysiwyg-content">
I just made a new DSN for a SQL Server Backend with an Access Frontend. &nbsp;The application is asking for the SQL Server password everytime I run the application. &nbsp;How do I go and change it so it remembers this SQL Server login when the application is run and doesn't prompt the user?
</div>
</div>


I just made a new DSN for a SQL Server Backend with an Access Frontend.  The application is asking for the SQL Server password everytime I run the application.  How do I go and change it so it remembers this SQL Server login when the application is run and doesn't prompt the user?

DSN Password

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.