I am trying to create a connection to my SQL Server via Access. I do not want to link tables as some of the tables in the DB are very large. I will be executing queries in Access that will pull out the information from SQL server.

```
Sub CreateConnection()

Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection

cnn.Open "Server=MBLWINDOWS-PC\SQLEXPRESS;Database=AdventureWorks2012; UserId=myUsername;Password=myPassword"

Debug.Print cnn.ConnectionString

cnn.Close

End Sub

```

The username and password to access the SQL server is the users windows login and password

How can i incorporate this in my connection string?