Updating data in a linked table is not supported
Once the process has been completed, you can build interfaces and queries to the linked tables just as you would for any Access database.
Use the following procedure to view links or to refresh them when the structures of the linked tables have changed.
However, the other side of this coin is that the optimizer is less able to push restrictions from the parent query down into a query will generally be evaluated as written, without suppression of rows that the parent query might discard afterwards.
For example, if you had a "Contacts" table and a "Companies" table, you could create a field that links each contact to the company they work for.
In the example above, clicking on the record for Lenore Maxwell would show us all of her information from the Contacts table, such as her picture and telephone number, and a preview of information about the New York Times from the Companies table.
Using this trick in production is not recommended, because other systems might work differently.
Also, it usually won't work if you make the outer query sort the recursive query's results or join them to some other table, because in such cases the outer query will usually try to fetch all of the query to avoid redundant work.