bsgbiz_com
Posts: 8
|
| Posted: 09/09/2005, 12:35 PM |
|
I understand how to connect to 1 datasource.
Can I connect to 2?
I'd like to use my MS SQL DSN and use an MS Access DSN.
I then will try to create queries that utilize both databases in the sql statements.
All of the builders and documentation that I have read refer to ONE data source.
( I know your first thought is WHY WOULD I WANT TO DO THAT?)
How can I do this? Will the query builder support it? 
_________________
Greg Bush |
 |
 |
peterr
Posts: 5971
|
| Posted: 09/09/2005, 12:48 PM |
|
Such questions were asked and answered here on the forums previously.
You can easily link to other databases from MS Access, and then you can create a single SQL query using Visual Query Builder. MS Access is a database, so it should understand your SQL statement, parse it, then connect to any other linked databases when needed, then assemble the results and send back to your application.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
bsgbiz_com
Posts: 8
|
| Posted: 09/09/2005, 1:07 PM |
|
I searched for the answer before asking. I guess I did not use the right search terms.
I understand what you are saying. Link my SQL database (Get External Data > Link Tables) from within Access. Right?
I will then upload the Access database to my web server and create a data source just for it.
I then won't need my SQL data source.
I'm already linked to my SQL database from Access. The Data Source for the server is created on my desktop. I'm not sure how the SQL link will work when I upload the Access database. I'll try it.
_________________
Greg Bush |
|
|
|
|
