How to Link to a Table in another Database in MS Access - Office 365

This video explains how you can link to a table in another database in MS Access. MS Access creates a linked table in destination database for the source table. Keep in mind the data always lives in source table only a link exists between source and destination databases for the table. If data is modified through source table or linked table the changes will be reflected in both places.

[jassem]

Hello, I have linked table i want convert that to local table, When the source adds new records Will these records be reflected in the table? Thank you, I've learned a lot from you.

[stanTrX]

Can you delete data from the destination db and source table also deletes?

[praveenkumarnagarajan]

Hi is it possible to create a link between two different system in a local network ?