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!

ODBC connection to remote server via tcp/ip?

Status
Not open for further replies.
SJG0526

SJG0526

Programmer
Jul 5, 2002
108
US
I need to distribute a MS Access 2003 mdb that will connect to SQL Server 2005 data on a remote server via tcp/ip. How could I do this in code so they can't see the connection userid and password? I'll be making an mde from it. I know how to programmatically create and use a connection string but not sure how to do this when the data server is accessed via the internet.

Thank you for your help.
 
Status
Not open for further replies.

Similar threads

bobbyer
  • Locked
  • Question
Ms Access VBA Automatic Relinking Frontend to 2 Backend via form
Replies
13
Views
337
bobbyer
bobbyer
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
398
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
244
dhookom
dhookom
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
178
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
253
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top