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

ADP Connection to SQL DB

Status
Not open for further replies.
vlree

vlree

IS-IT--Management
Joined
Jan 16, 2004
Messages
31
Location
US
I have a blank adp that I would like to use as a front end for a sql db that runs our website.

How do I set up the connection? First time. thanks
 
Sort by date Sort by votes
Go to File/Connection. In there enter the IP address of your SQL server name, login, password and select the database on the SQL server that you want to connect to using your access project. That's it. You should be able to see all the tables that you have access to under the tables tab in your project if you succeed in connecting.

Good luck,
Rebooot
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question Question
Use domain accounts to log in to Access database
Replies
0
Views
4K
breezett93
breezett93
dw134
  • Locked
  • Question Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
3K
dw134
dw134
batteam
  • Locked
  • Question Question
Need help with .adp report recordsource
Replies
1
Views
713
genomon
genomon
batteam
  • Locked
  • Question Question
Importing Excel data to SQL table using MSAccess .adp
Replies
3
Views
2K
lameid
lameid
techstudent01
  • Locked
  • Question Question
Convert MS Access SQL queries to AIX SQL queries
Replies
0
Views
3K
techstudent01
techstudent01

Part and Inventory Search

Sponsor

Back
Top