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!

ADP Connection to SQL DB

Status
Not open for further replies.
vlree

vlree

IS-IT--Management
Jan 16, 2004
31
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
Use domain accounts to log in to Access database
Replies
0
Views
383
breezett93
breezett93
dw134
  • Locked
  • Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
342
dw134
dw134
batteam
  • Locked
  • Question
Need help with .adp report recordsource
Replies
1
Views
188
genomon
genomon
batteam
  • Locked
  • Question
Importing Excel data to SQL table using MSAccess .adp
Replies
3
Views
351
lameid
lameid
techstudent01
  • Locked
  • Question
Convert MS Access SQL queries to AIX SQL queries
Replies
0
Views
341
techstudent01
techstudent01

Part and Inventory Search

Sponsor

Back
Top