Comments by Jean-Claude Elias (Top 2 by date)

Jean-Claude Elias 21-Nov-22 5:02am View

Thank you very, very much. The URL/webpage you provided helped me correct the syntax of my connection string. Now my code works as it should, without prompting me for the password. Thanks again - much appreciated.

Jean-Claude Elias 21-Nov-22 1:01am View

Yes I do, but it still asks for it when I run the code. Once password is entered, manually, the connection works alright. Is there any syntax or structure error in my connecting string? Here is the entire code.

=======================================================================
Dim strConnectionString as string
Dim strDBName as string
Dim strMyUsername as string
Dim strMyPassword as string
Dim strTblNameInSQLServer as string
Dim strTblNameInAccess as string

strDBName = “AllMembers”
strMyUsername = “claude”
strMyPassword = “123” ' just for testing purpose
strTblNameInSQLServer= “tblMembers”
strTblNameInAccess = “dbo_tblMembers”

strConnectionString = "ODBC;DRIVER=SQL Server Native Client 11.0; " & _
"SERVER=JCRE\SQLEXPRESS;DATABASE=" & strDBName & ";User Id=" & strMyUsername & ";Password=" & strMyPassword

DoCmd.TransferDatabase acLink, "ODBC Database", _
strConnectionString, acTable, strTblNameInSQLServer, strTblNameInAccess