Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Unanswered: MS Access Error 2147217887

    I am brand new to this group so please excuse me if I am asking a question that has been asked before.

    I get this error when reaching the update in this code:

    PartnerInit = rsPartnerCompSel.Fields("PartnerInit")
    ManagingInit = rsPartnerCompSel.Fields("ManagingInit")
    MatterCode = rsPartnerCompSel.Fields("MatterCode")
    OriginatingPct = rsPartnerCompSel.Fields("OriginatingPct")
    ManagingPct = rsPartnerCompSel.Fields("ManagingPct")
    ManagingFactor = CalcMgtFactor(PartnerInit, ManagingInit, ManagingPct, OriginatingPct, MatterCode)
    rsPartnerCompSel!ManagingFactor = ManagingFactor

    I get the additional error:
    The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

    I'm the only one on my laptop.

    Any thoughts?

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Is there a form open that is bound to the same table that the recordset is?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts