[vba] strConn = "PROVIDER=sqloledb.1;"
strConn = strConn & "Network Library=dbmssocn;"
strConn = strConn & "DATA SOURCE=SQLServer2005Name\SQLEXPRESS;"
strConn = strConn & "INITIAL CATALOG=YourDatabaseName;"
strConn = strConn & "Integrated Security=SSPI"[/vba]
I'm confused, is strConn the connection object or a string variable containing the connection object's connection string?