Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TransferDatabase with NT Authentication

Status
Not open for further replies.
03Explorer

03Explorer

Technical User
Sep 13, 2005
304
US
How do I use ODBC DSN with out having to code in the username or password. I want the connection to use the NT authentication that was set for the DSN. What is the command line to use for this?

My Current line
Code: 
DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=CLINICAL_ARTEMIS;UID=;PWD=;LANGUAGE=us_english;" _
    & "DATABASE=CLINICAL_ARTEMIS", acTable, "StudySite", "StudySite"
Thanks
 
Status
Not open for further replies.

Similar threads

M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
413
SoftwareRT
SoftwareRT
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
195
Dan Stoica
Dan Stoica
JaineyBlue
  • Locked
  • Question
DLookup with criteria 1
Replies
2
Views
177
JaineyBlue
JaineyBlue
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
225
TheAceMan1
TheAceMan1
theConjurian
  • Locked
  • Question
Assistance with where clause coding
Replies
5
Views
167
combo
combo

Part and Inventory Search

Sponsor

Back
Top