locked
Migrating Access Database from one machine to another RRS feed

  • Question


  • We tried to migrate MS Access 2016 database from one machine to another. But during the process second machine bugged. We tried to repeat the process, but on source machine Microsoft Access showed us a message The database 'FileName.mdb' needs to be repaired or isn't a database file. We tried to Compact&Repair function, but didn't handle it. It happened yesterday, now we don't have access to our database. Someone, suggest something that could allow to get this message rid of.

    Sunday, April 8, 2018 7:00 PM

Answers


  • We tried to migrate MS Access 2016 database from one machine to another. But during the process second machine bugged. We tried to repeat the process, but on source machine Microsoft Access showed us a message The database 'FileName.mdb' needs to be repaired or isn't a database file. We tried to Compact&Repair function, but didn't handle it. It happened yesterday, now we don't have access to our database. Someone, suggest something that could allow to get this message rid of.

    The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition or helpful resources that advise professionals to repair microsoft access database

    http://allenbrowne.com/recover.html

    https://msdn.microsoft.com/en-us/library/bb243863(v=office.12).aspx

    https://www.repairtoolbox.com/accessrepair.html

    1. Do not open Access database must closed

    2. Sufficient storage space available - minimum double in size of your Access database on that Disk.

    3. Close the .mdb file related to .ldb file before you delete the .ldb file.

    4. Then Run the Compact and Repair tool


    • Marked as answer by CooperElois Thursday, April 26, 2018 5:24 PM
    Saturday, April 14, 2018 11:48 AM

All replies

  • Do you have a backup you could simply restore?

    What about creating a new blank db and then trying to import everything from the corrupted one.

    How exactly did the second machine bug?


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, April 8, 2018 7:08 PM
  • There are a few options if you can't get a backup.

    First try a restore from a previous version via the file history. (right Clic on the file, select Properties > Previous versions...

    Or if that fails see: https://www.techrepublic.com/article/picking-up-the-pieces-recovering-corrupt-access-databases/


    Brian, ProcessIT- Hawke`s Bay, New Zealand

    Sunday, April 8, 2018 11:41 PM
  • Hi CooperElois,

    You can also try to visit the link below and try to follow the steps mentioned in the link which may help you to recover your database.

    How to troubleshoot and to repair a damaged Access 2002 or later database

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, April 9, 2018 3:42 AM

  • We tried to migrate MS Access 2016 database from one machine to another. But during the process second machine bugged. We tried to repeat the process, but on source machine Microsoft Access showed us a message The database 'FileName.mdb' needs to be repaired or isn't a database file. We tried to Compact&Repair function, but didn't handle it. It happened yesterday, now we don't have access to our database. Someone, suggest something that could allow to get this message rid of.

    The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition or helpful resources that advise professionals to repair microsoft access database

    http://allenbrowne.com/recover.html

    https://msdn.microsoft.com/en-us/library/bb243863(v=office.12).aspx

    https://www.repairtoolbox.com/accessrepair.html

    1. Do not open Access database must closed

    2. Sufficient storage space available - minimum double in size of your Access database on that Disk.

    3. Close the .mdb file related to .ldb file before you delete the .ldb file.

    4. Then Run the Compact and Repair tool


    • Marked as answer by CooperElois Thursday, April 26, 2018 5:24 PM
    Saturday, April 14, 2018 11:48 AM
  • Hi CooperElois,

    Is your issue solved?

    I find that you did not follow up this thread after posting the issue.

    If your issue is solved then I suggest you to post your solution and mark it as an answer.

    If your issue is still exist then try to refer the solution given by the community members.

    If then also you have any further questions then let us know about it.

    We will try to provide further suggestions to solve the issue.

    Thanks for your understanding.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, April 16, 2018 1:02 AM