Tables from different databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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.
 
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
 
Back
Top