Linking to tables from another SQL database

Hi
I have an adp, lets say it linked to SQL database called SQL_A.
In another SQL database, SQL_Staff, there is a list of staff.
I need to look up that list in my adp. However, as an adp can only link to
one database, how do I get around this?
Is is possible to create a view in SQL_A that links to the table in
SQL_Staff?
The staff list changes on a daily basis, and SQL_A would need to be able to
see the updated list at any time.
Regards
Vayse


.

Relevant Pages

  • Re: Linking to tables from another SQL database
    ... like table creation; the table creation in 2000 is a lot better than ... Sylvain - I don't get that option in my adp. ... I have an adp, lets say it linked to SQL database called SQL_A. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Linking to tables from another SQL database
    ... that is because Microsoft sent up a bunch of retards to market this ... feature. ... the benefits of ADP are everywhere and retarded blu-heads are still ... lets say it linked to SQL database called SQL_A. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: DoCmd.TransferText Access ADP
    ... > "Stored Procedures" (After Access XP, ... ADP is different from MDB, ... >> I tried with the dbo and and as well the ownerfor both the access ... >> the SQl database name but the same result. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Linking to tables from another SQL database
    ... this naming convention database.owner.object allows you to ... I have an adp, lets say it linked to SQL database called SQL_A. ... The staff list changes on a daily basis, and SQL_A would need to be able to ...
    (microsoft.public.access.adp.sqlserver)
  • ADP Stock Watch
    ... ADP public relations or stock investor offices to check this out. ... because they decided to do this without additional staff except a few ... passwords on systems have to be changed so frequently, ...
    (misc.invest.stocks)
Loading