Will we lose data when migrating from Microsoft Access?
A properly planned migration should preserve required historical and active data, but validation must be designed into the project rather than assumed.
A properly planned migration should preserve required historical and active data, but validation must be designed into the project rather than assumed.
What this means in practice
Before migration, the team should identify duplicate records, invalid values, missing keys, inconsistent dates, attachments, calculated fields, and business rules that affect interpretation.
The practical next step
Some obsolete or low-quality data may intentionally be archived instead of loaded into the new system. Those decisions should be documented so omission is deliberate and reversible.
This answer provides general guidance. The right recommendation depends on your application, data, users, licensing, and business requirements.