Link MS SQL Server 2000 Tables
Hello All,
I am new to this forum and hope that some one can help me with this problem.
I know that in MS Access you can have a linked table in your databse such that as long a the like is not broken, it behaves similar to any other table in the database.
My problem is that I need to do the same thing for multiple databases that I have on a MS SQL Server that ALL currently have copies of the same table in common.
I wish to have a single table that they all share and have access to just link any other table that they currently have but is actually linked.
Can this be done?
And if so, then could someone please guide me in this?
My logic is that if MS Access can link tables then I could suspect that MS SQL Server should be able to also, but I could be wrong.
Thanks in advance,
Lonnie