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

    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
    rsPartnerCompSel.Update

    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
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Is there a form open that is bound to the same table that the recordset is?
    Paul

Posting Permissions

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