"record(s) could not be modified because they were in use by other users ..." Error when doing relookup
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