Tables from different databases

[JuanPi]

How can I make an ADP qith tables from different sql server databases?

Now I use a view like select * from otherdatabase..table, but there are a
better method?

Thanks

 

[Graham R Seach]

Juan,

Just link the tables via ODBC. Then you can refer to the tables without
regard to their database of origin.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Graham R Seach]

Juan,

Sorry, I just realised you were talking about an ADP.

If you use Enterprise Manager, or other such tool, to attach the other
databases as linked servers, then create distributed views to represent
those tables, you can refer to the views as though they were tables.

But I think you'd be better served by using an MDB instead of ADP, and
linking the tables via ODBC.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Norman Yuan]

Beside Braham's suggestion, you can write VBA code by using ADO to open
connection to any available data source, besides curently connected SQL
Server, to get data.

 

[Vadim Rapp]

Hello JuanPi:
You wrote in conference microsoft.public.access.adp.sqlserver on Fri, 15
Apr 2005 02:12:01 -0700:

J> How can I make an ADP qith tables from different sql server databases?

J> Now I use a view like select * from otherdatabase..table, but there are
J> a better method?

No, it's the best method indeed.

Vadim Rapp