Thanks! The idea of deleting the old triggers and replacing them with new triggers worked.

Tony

Here's the trigger on one of them:

CREATE TRIGGER "tblCustomerName_DTrig" ON dbo.tblCustomerName FOR DELETE AS

SET NOCOUNT ON

/* * CASCADE DELETES TO 'tblCustomerChallenge' */

DELETE tblCustomerChallenge FROM deleted, tblCustomerChallenge WHERE deleted.strCustID = tblCustomerChallenge.strCustID

/*...