none
Corrupt Access 2010 Files RRS feed

  • Question

  • I have a corrupt file and I wanted to use the SaveAsText and LoadFromText to try and salvage it, but the references that I find want me to Save and Load all of my files in my database. Is it possible to only do 1 at a time?

    Dean J. Waring

    Friday, October 28, 2016 6:28 PM

Answers

  • Do you know which object is corrupted? If yes, then create a new empty database and import all objects except the corrupted one with the Import wizard.

    If you don't know, start to import all objects. This will stop at the corrupted object and show you its name. Repeat the import, but leave out the corrupted object and the objects that were already imported without errors, etc.

    Using the Import wizard is usually more stable than directly using SaveAsText/LoadFromText. These can somtimes have problems dealing with images.

    Matthias Kläy, Kläy Computing AG

    • Marked as answer by DeanJW2006 Monday, October 31, 2016 8:16 PM
    Sunday, October 30, 2016 11:44 AM
  • I have a corrupt file and I wanted to use the SaveAsText and LoadFromText to try and salvage it, but the references that I find want me to Save and Load all of my files in my database. Is it possible to only do 1 at a time?

    Dean J. Waring

    SaveAsText and LoadFromText work on individual objects, so 1 at a time.  That said, usually when facing the need to use such code you perform a simple loop to export/import the objects.

    Long story short, simply make an individual call to the command, remove the loop.

    The basic syntax can be found at https://blogs.msdn.microsoft.com/thirdoffive/2006/08/31/templates-quick-overview-of-saveastext-and-loadfromtext-aka-lets-get-boring-again/

    I'm also curious as to your diagnosis of corruption.  Have you decompiled/C&R/compile/C&R?  Have you imported everything into a new blank database file?  What makes you think it's corrupted?


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



    Sunday, October 30, 2016 12:46 PM
  • Hi

    Allen Browne pages has helped me more than once.

    Recover from corruption and how to prevent


    Best // Peter Forss Stockholm and Sigtuna GMT +1.00

    • Marked as answer by DeanJW2006 Monday, October 31, 2016 8:16 PM
    Sunday, October 30, 2016 5:16 PM

All replies

  • Do you know which object is corrupted? If yes, then create a new empty database and import all objects except the corrupted one with the Import wizard.

    If you don't know, start to import all objects. This will stop at the corrupted object and show you its name. Repeat the import, but leave out the corrupted object and the objects that were already imported without errors, etc.

    Using the Import wizard is usually more stable than directly using SaveAsText/LoadFromText. These can somtimes have problems dealing with images.

    Matthias Kläy, Kläy Computing AG

    • Marked as answer by DeanJW2006 Monday, October 31, 2016 8:16 PM
    Sunday, October 30, 2016 11:44 AM
  • I have a corrupt file and I wanted to use the SaveAsText and LoadFromText to try and salvage it, but the references that I find want me to Save and Load all of my files in my database. Is it possible to only do 1 at a time?

    Dean J. Waring

    SaveAsText and LoadFromText work on individual objects, so 1 at a time.  That said, usually when facing the need to use such code you perform a simple loop to export/import the objects.

    Long story short, simply make an individual call to the command, remove the loop.

    The basic syntax can be found at https://blogs.msdn.microsoft.com/thirdoffive/2006/08/31/templates-quick-overview-of-saveastext-and-loadfromtext-aka-lets-get-boring-again/

    I'm also curious as to your diagnosis of corruption.  Have you decompiled/C&R/compile/C&R?  Have you imported everything into a new blank database file?  What makes you think it's corrupted?


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



    Sunday, October 30, 2016 12:46 PM
  • Hi

    Allen Browne pages has helped me more than once.

    Recover from corruption and how to prevent


    Best // Peter Forss Stockholm and Sigtuna GMT +1.00

    • Marked as answer by DeanJW2006 Monday, October 31, 2016 8:16 PM
    Sunday, October 30, 2016 5:16 PM