A Question about Views

[levinll]

Is it possible to create a view in one database that uses a table from a different database ? If so, how ?

 

[zemp]

I have never heard of this being done, but that doesn't mean it can't be done. I don't know, my initial reaction is to say no, but I have been wrong before.

You might want to pose this question in a database forum for a more definative answer. You can try the VB database forum that is part of tek-tips or there is a link to the microsoft SQL server forum in the related forums section of this page. Thanks and Good Luck!

zemp

 

[levinll]

I'll do that. I'm trying to share a table (an employee information table) that will be common to many database application. It seems silly to have copies of the same table in each database that needs it.

 

[bmoyer23]

If you are using Access, just link the table(s) to the database that you are creating the view.

 

[levinll]

I'm using SQL Server as a back end, and VB as a front end.

 

[CodeFish]

Yes it is popssible see an example below:-

NB/
Mortgages Table is in SQL Database Called Mortgages
Companies Table is in SQL Database Called Misc
View Created in Mortgages Database

Code:
CREATE VIEW dbo.[VW_Mortgages]
AS

/* Add Company Name to View - Standardised Display Name for Company*/
SELECT MISC..[Companies].CompanyTitle, Mortgages.Rate

....


/* Table Join:*/
FROM [Mortgages] INNER JOIN MISC..[Companies] ON Mortgages.COMPNO = MISC..[Companies].AKACODE



Regards,

Codefish

 

[levinll]

I got the view to work. Thanks !