To anyone who cares:

After some research and dumb luck I found out that the vfp ole-db driver does not support macro expansion in triggers. That is what was causing the trigger to fail.

Bob