Corrupt Access 2010 Files

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

Answer 1

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

Answer 2

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

Answer 3

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