AnsweredAssumed Answered

"record(s) could not be modified because they were in use by other users ..." Error when doing...

Question asked by JillianDunic on Nov 19, 2012
Latest reply on Nov 20, 2012 by JillianDunic

Title

"record(s) could not be modified because they were in use by other users ..." Error when doing relookup

Post

      

     When I attempt to relookup or recalculate a field, I get this error message: "900 record(s) could not be modified because they were in use by other users or your privileges do not allow you to change them."

     I do not have any self joins, I am logged in as the Admin with Full Access privileges, I have no extra windows open. I have even quit and reopened (and double checked I was logged in as Admin) and tried the lookup again using both relookup and recalculate but both ways I receive the same error message. What could be causing this?

     Here is a description of my tables and lookup:

     I have two tables:

     Specimens(pk_SpecimenID, OldName, ...) and
     Spares(pk_SpareID, fk_SpecimenID, ref_OldName, ...)

     To do this lookup, I have created a second table occurrence of Specimens which I have called SpecimensForSpares. I then have the following relationships:

     SpecimensForSpares :: OldName = Spares :: ref_OldName
     Spares :: fk_SpecimenID = Specimens :: pk_SpecimenID

     My lookup is then defined for the Spares :: fk_SpecimenID as
     Starting with table Spares
     Lookup from related table: SpecimensForSpares :: pk_SpecimenID

     Thanks.

Outcomes