Error de infracciones de bloqueos

%3CLINGO-SUB%20id%3D%22lingo-sub-2316621%22%20slang%3D%22es-ES%22%3ECrash%20violations%20failed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316621%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20am%20developing%20a%20new%20database%20in%20the%20company%20and%20it%20turns%20out%20that%20after%20creating%20an%20update%20query%20%22UPDATE%22%20that%20runs%20when%20I%20press%20a%20button%20there%20are%20records%20in%20which%20I%20get%20the%20following%20error%20and%20others%20in%20which%20I%20update%20it%20directly.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Error.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277452i95174B0CC1CA9E4E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Error.JPG%22%20alt%3D%22Error.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EUnfortunately%20I%20have%20not%20managed%20anywhere%20to%20get%20relevant%20information%20or%20to%20help%20me.%3C%2FP%3E%3CP%3ESomeone%20can%20know%20what's%20going%20on...%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20the%20Access%202013%20version%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2316621%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EErrors%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EVba%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2321862%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20de%20infracciones%20de%20bloqueos%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1043490%22%20target%3D%22_blank%22%3E%40Manuel1180%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20am%20interpreting%20the%20error%20message%20correctly%2C%20one%20of%20the%20records%20you%20are%20trying%20to%20update%20in%20the%20query%20can't%20be%20updated%20due%20to%20an%20%22infraccion%20de%20bloqueo%22%2C%20which%20I%20think%20translates%20to%20a%20violation%20of%20a%20key%20or%20index.%20In%20other%20words%2C%20you%20may%20be%20trying%20to%20update%20a%20primary%20key%20or%20index%20to%20a%20value%20that%20would%20create%20a%20duplicate%20in%20a%20field%20that%20must%20be%20unique.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThat%20would%20be%20my%20first%20guess%3B%20there%20may%20be%20another%20reason.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Buenos Días, 

Estoy desarrollando una base de datos nueva en la empresa y resulta que después de crear una consulta de actualización "UPDATE" que se ejecuta al pulsar un botón hay registros en los que me sale el siguiente error y otros en los que me lo actualiza directamente.

Error.JPG

Por desgracia no he conseguido en ningún sitio conseguir información relevante o que me ayude.

Alguien puede saber que sucede...??

 

Uso la versión Access 2013

1 Reply

@Manuel1180 

If I am interpreting the error message correctly, one of the records you are trying to update in the query can't be updated due to an "infraccion de bloqueo", which I think translates to a violation of a key or index or another restraint. In other words, you may be trying to update a primary key or index to a value that would create a duplicate in a field that must be unique. 


That would be my first guess; there may be another reason.