5 Replies Latest reply on Nov 20, 2012 11:39 AM by JillianDunic

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

    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.