Designing a SQL Server trigger for use with Access front-end

[Ben Clothier]

For those with an Access application that ties into a SQL Server backend, you might be interested in reading about considerations for designing a trigger. A follow up blog post on specific consideration for Access bound form will follow shortly.

Designing a T-SQL Trigger

[#2]

Thanks, Ben!

Excellent tips regarding use of Set (vs. Row)-based Triggers attached to a View in SQL Server.

I look forward to your follow-up article about using this with Access.