Re: Linking to tables from another SQL database

Thanks guys, will give that a try and get back to you if I have any issues.


"Kevin3NF" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OhKPeCyPHHA.4364@xxxxxxxxxxxxxxxxxxxxxxx
Cool...didn't know you could create linked tables from within the ADP
interface :)

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%234bitsxPHHA.4172@xxxxxxxxxxxxxxxxxxxxxxx
If it's located onto another server and you don't remember the T-SQL
syntax, the File | Get External Data | Link Tables... will create the
linked server and its associated view for you. You might want to play
with this option.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Kevin3NF" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23%23Nm%238vPHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Look up "Linked Servers" in SQL Server books online if the two databases
are on different servers.

If on the same server create a view that uses the database name in
thefrom list

Create View myView as
Select *
From SQL_Staff..MyStaffTable join
SQL_A..MyOtherTable on SQL_Staff..MyStaffTable.ID =
SQL_A..MyOtherTable.id
Where whatever....

Use that view in your ADP

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"Vayse" <vvv> wrote in message
news:ubQ3uMtPHHA.140@xxxxxxxxxxxxxxxxxxxxxxx
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: Access Project connecting to multiple SQL Servers
    ... I have heard that Microsoft IS working on a patch for this; ... cannot be used to create server objects on SQL ... since ADP is on its way of phasing out. ... allows creating server object on SQL Server 2005 or not (it still support ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access Project connecting to multiple SQL Servers
    ... don't think the statement that ADP is phasing out is accurate. ... SQL Server Migration Assistant ... This version of Microsoft Office Access doesn't support design ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access Project connecting to multiple SQL Servers
    ... Access2007 will support creating server objects on SQL Server 2005. ... don't think the statement that ADP is phasing out is accurate. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Official Status of SQLServer 2005 ADP
    ... I am a big fan of the ADP/SQL server combination. ... This allows the SQL server to only ... One of the advantages that I've found to using ADP is the "implied" ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Linking to tables from another SQL database
    ... Sylvain - I don't get that option in my adp. ... Real-world stuff I run across with SQL Server: ... lets say it linked to SQL database called SQL_A. ...
    (microsoft.public.access.adp.sqlserver)