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

How do you add 2 seperate Databses

Status
Not open for further replies.
dpwsmw

dpwsmw

MIS
Apr 2, 2003
76
US
Can you add 2 seperate Databases from SQL to one ADP? Can it be done, and can someone send me a HowTo
 
Sort by date Sort by votes
You can only add one SQL database to an adp.
However, you can use ADO code to connect to virtually any number of databases, but you have to know the connection settings and the objects in the other databases. Plus...the permissions...

It's all in the connection string in your code...

HTH


[pipe]
Daniel Vlas
Systems Consultant

 
Upvote 0 Downvote
There are different options depending on your requirements. What are the requirements?
 
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
2K
breezett93
breezett93
LittleNick
  • Locked
  • Question
Can Quick Access Toolbar be disabled in Access 2010?
Replies
0
Views
1K
LittleNick
LittleNick
toptech
  • Locked
  • Question
How do I pass form field into criteria of stored procedure
Replies
2
Views
315
toptech
toptech
InspectorHound
  • Locked
  • Question
Creating an MS Access 2013 project with multiple forms
Replies
1
Views
1K
lameid
lameid
ashrafalani
  • Locked
  • Question
this code does not work in access project
Replies
0
Views
1K
ashrafalani
ashrafalani

Part and Inventory Search

Sponsor

Back
Top