This line:
GuardianID = "G" & Region & Right(1000000 + GetNewGuardianID, 6)
is bothersome. You should really never calculate a smart ID for a multi-user OLTP system and use that as the primary key. If I understood what you said in your first post correctly, cross contamination occurs between...