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 Mike Lewis 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
0
0
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

Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
76
Dan Stoica
Dan Stoica
JaineyBlue
  • Locked
  • Question
DLookup with criteria 1
Replies
2
Views
99
JaineyBlue
JaineyBlue
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
115
TheAceMan1
TheAceMan1
theConjurian
  • Locked
  • Question
Assistance with where clause coding
Replies
5
Views
94
combo
combo
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
99
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top