D
Deano
I'm using TransferDatabase to export the contents of an
Access query to a SQL Server table. I'm using Windows
Authentication to get into the SQL Server. this is the
connection string and code I'm using:
strConnString = "ODBC;DRIVER={SQL Server};SERVER=SJH-
SQL;Integrated Security=SSPI;" & "APP=Microsoft®
Access;WSID=;LANGUAGE=us_english;DATABASE=FIN_TrialBalance;
TABLE=dbo.tblR11_MainRpt"
DoCmd.TransferDatabase acExport, "ODBC Database",
strConnString, acQuery, "R11 - QUERY FOR MAIN REPORT
(All)", "tblR11_MainRpt"
Unfortunately, this gives me a pop up box asking for the
user's ID and password. How can I eliminate this dialog
box, and tell the function to just use the user's Windows
Network ID and Password?
TIA
Deano
Access query to a SQL Server table. I'm using Windows
Authentication to get into the SQL Server. this is the
connection string and code I'm using:
strConnString = "ODBC;DRIVER={SQL Server};SERVER=SJH-
SQL;Integrated Security=SSPI;" & "APP=Microsoft®
Access;WSID=;LANGUAGE=us_english;DATABASE=FIN_TrialBalance;
TABLE=dbo.tblR11_MainRpt"
DoCmd.TransferDatabase acExport, "ODBC Database",
strConnString, acQuery, "R11 - QUERY FOR MAIN REPORT
(All)", "tblR11_MainRpt"
Unfortunately, this gives me a pop up box asking for the
user's ID and password. How can I eliminate this dialog
box, and tell the function to just use the user's Windows
Network ID and Password?
TIA
Deano