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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do I setup the ADO connection to an SQL server

Status
Not open for further replies.
plshelpme

plshelpme

Programmer
Nov 1, 2001
27
0
0
CA
Hi I need the very basic steps to set up a connection from my local MS-Access a SQL Server DB. Is there somewhere that I can go to just select the ODBC that I have set up for that DB??

Thanks
 
Sort by date Sort by votes
The best way to connect to Sql Server is through an Access project. Create an Access adp file and under file on the menubar there will be connection. Connect to your sql server and database.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
102
ziffer68
ziffer68
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
61
IrishJim
IrishJim
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
180
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
157
combo
combo
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
46
btamsgn
btamsgn

Part and Inventory Search

Sponsor

Back
Top