Linking Databases

[DelMar]

Does anyone know if there is any way to link to seperate databases so that any information entered in one will update the same information in the other and visevirsa?

Thanks

 

[namliam]

If you have information that needs to be shared, then it should indeed be shared and not stored seperatly (needed updates).

Simply store your information in 1 place and updates will automagicaly be done across the board.

Regards

 

[ScottGem]

You can link to tables in as many databases as necessary. Any changes made to a linked table are reflected in the database those tables reside in.

 

[IgorB]

You can link to tables in as many databases as necessary. Any changes made to a linked table are reflected in the database those tables reside in.

As far as data, you are correct. If we are talking about table structure, it depend on what database type we use. When you having deal with SQL Server linked table any structure changes required to be relink again.