Rick Brandt wrote:

> Jim Devenish wrote:

> If all updates and insertions are done in your Access app via forms then you can
> link to the SQL Server tables and then use code in your forms that push
> identical updates to the SQL Server link.

But this risks making a mistake in the code. Before going down this
road, you should definitely evaluate migrating the back end from Jet
to SQL Server, thus allowing triggers.

Failing that, if near-real-time is acceptable, then create a stored
procedure that updates SQL to match Jet, and an Agent job to run that
procedure at some appropriate frequency.