Post reply

bound data and triggers

  • February 28, 2006 at 12:51 pm

    #67277

    I have a form (data sheet) bound to a table with a trigger. Even though the trigger does not update this table, access prompts that the record was changed and ask to save or drop the changes. Is there a work-around?

  • March 1, 2006 at 2:32 pm

    #624141

    Kevin,

    I can't recreate this error. Are you using an mdb or an adp? What is happening in the trigger? Could there be concurrency issues with the table it's updating?

    You might try trapping for the error in the Form_Error event.

    Barry

  • March 1, 2006 at 2:45 pm

    #624145

    thank you for the reply..

    I am using an adp. It doesn't prompt as an error. It's a special record lock message. I will try to reproduce it tomorrow.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply