Migrate Microsoft Access Database to the latest version in new server

Litty Kuriakose 106 Reputation points
2021-11-12T12:37:59.957+00:00

Planning to migrate Microsoft access Database ( file format :mdb) from MSAccess 2010 to latest version (MS Access 2019/Office 365) in new server

Please guide with the steps to migrate the database file to latest version?

Please share any checklists or things to analyzed prior to migration.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
727 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Philippe Levesque 4,211 Reputation points Microsoft MVP
    2021-11-12T13:26:14.843+00:00

    Hi

    For such step usually you just have to save your file to a newer version, and after you need to validate if your database still work ok.

    Does the .MDB came from an earlier version ? like '97 ? If so, in your 2010 make sure to save it as a correct file format, and after in the newer version of Access save it to a .accdb's file.

    I would check such blog (Converting Microsoft® Access Databases or "Cannot Open a database created with a previous version of your application" in Access 2013 and Access 2016) in example for information.

    Thanks

    No comments