I have an SQL Server at our main office, and an access database at a site office, which has the same table. You could say the access table is an offline version of the SQL table.

What I need to figure out is if there is any way to update the Access table based on SQL Server triggers (i.e. when records in the original table are changed).

Thanks for the help.