http://www.connectionstrings.com/default.aspx?carrier=sqlserver
Per a recent post, I've found this internet site may help, but i need a boost on how to get this information into vba sintax.
Driver={SQL Server};Server=myServerAddress;Database=myDataBase ;Uid=myUsername;Pwd=myPassword;
Hello popoyan78!
I think you'll find whether through VB or VBA, it is pretty much the same thing. If it's working in VB, you;re straight, don't quote me on that though, not sure of the scope of you project, hee hee:-)
But I am going to add it to the Access forum anyway, you can more questions there if you like.
Also, thanks for letting us know you found an answer, it's nice.
In a bit!