<div>
<div class="content wysiwyg-content">
I have an application written in Access 2007 that has SQL Server back-end (linked tables via ODBC). &nbsp;All works great except the first time I open the application, a SQL Server Login screen appears (in access) after the first query is run asking for a username/password to the SQL Server. &nbsp;Subsequently, I never see this login screen until I restart my computer and run the application again. &nbsp;<br />
<br />
I don't want the user to have to enter this information as it's not appropriate for my application. &nbsp;The user's username/password is stored in a DB table, not on the SQL Server as a login. &nbsp;I would like to automatically create the application connection when my &quot;Startup Form&quot; appears.<br />
<br />
Related question: How are connections managed in ACCESS? Does Access maintain any sort of connection pool?
</div>
</div>


I have an application written in Access 2007 that has SQL Server back-end (linked tables via ODBC).  All works great except the first time I open the application, a SQL Server Login screen appears (in access) after the first query is run asking for a username/password to the SQL Server.  Subsequently, I never see this login screen until I restart my computer and run the application again.  

I don't want the user to have to enter this information as it's not appropriate for my application.  The user's username/password is stored in a DB table, not on the SQL Server as a login.  I would like to automatically create the application connection when my "Startup Form" appears.

Related question: How are connections managed in ACCESS? Does Access maintain any sort of connection pool?

How to create the initial connection from Access to SQL Server

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.