Imported item 20
Database lock is a controlled milestone in clinical data management after which routine changes to a study database are restricted. The team establishes a stable dataset for analysis following its agreed review and approval process. Lock protects the integrity of the analysis, but does not make the records anonymous.
Key Takeaways
- Resolve or formally document outstanding data issues before approving the locked version.
- Distinguish a temporary data freeze from the final lock defined in the study procedure.
- A locked database does not, by itself, determine the response to a participant’s privacy request.
What Happens Before Database Lock?
EMA’s guidance on computerised systems addresses data confirmation, investigator access and retaining an adequate copy of trial records. It explains that access can become read-only at lock and that investigator review and confirmation should occur throughout the trial. We recommend a study-specific checklist covering unresolved queries, medical coding, safety reconciliation and approved exclusions. Define who authorises lock and how any exceptional later correction is assessed, documented and communicated to the analysis team.
Primary guidance: EMA computerised systems guideline.
Why It Matters for Data Protection
For a hypothetical sponsor receiving a correction request after lock, we recommend opening a documented assessment rather than silently editing the analysis dataset or refusing solely because it is locked. Identify the relevant record, applicable rights, research obligations and potential effect on completed analyses. Preserve the original version and audit trail where required. Coordinate the privacy, clinical and statistical decisions, and explain the outcome to the requester through the appropriate channel. Lock is a data-integrity control, not a replacement for a reasoned privacy assessment.
Frequently Asked Questions
Is a freeze always a final lock?
No. The study procedure should explain the status and permitted changes.
Can locked data ever change?
An exceptional change should follow the defined approval, documentation and version-control process.
Does lock remove personal data rights?
No automatic conclusion follows from lock; assess the particular request and applicable law.
Related reading: electronic data capture edc; query clinical data query.
Explore iliomad’s clinical trials support for your organisation.
Updated: 27 October 2026
