linked databases

[LloydDobler]

Hello everyone. Is it possible to link tables in separate databases on the same server, or link databases? If so how, if not, what would be the way around this? Our situation is we have one database that has employee info, and another database with production info, and we need to link the employee# from one to the other. Any help would be great. Thanks

Al

 

[LloydDobler]

Okay, I've scheduled a DTS package to run which seems to work. If this is a bad idea, or there is a better way to do it please let me know.

 

[JayKusch]

When you say "link", what are you refering to? Are you trying to SELECT data from two tables on diffrent databases? If so, you would do the following:

SELECT *
FROM EmployeeInfo as E -- in Employee Database
JOIN Production.dbo.Items as I -- in Production DB
ON (E.Employee_ID = I.Employee_ID)


Thanks

J. Kusch

 

[eggy168]

Hi, I have the similar case. I don't know should I post it in there or start a new threat. Anyhow, this is my situation. I am using Access 2000 as the front end, and I want to link two tables from two different databases in SQL2K. It works no problem, however, one of the problems is people have to logon twice. Is there anyway to avoid two login screen and syn to once?

 

[Corran007]

i believe that is an access issue. you should try the access forum