create a linking dinamiclly from two table in access mdb

[sal0003]

I have a data base on sql server (i have permission only to read this database) and a access database on c:\ and a table1 with the same fileds and struccture of sql table.
Is possible to make a dinamic link from the two table in this mode,Similar:
new recordset added in sql table, add the new records also on access table, a recordset from sql table is deleted, delete the same recordset on access table.. ecc...

 

[kjv1611]

http://www.brighthub.com/computing/windows-platform/articles/28501.aspx

http://office.microsoft.com/en-us/access/hp052416951033.aspx

http://www.lmgtfy.com/?q=microsoft+access+linked+tables