Connection string for ODBC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top