Answered by:
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
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
- Edited by Daniel Pineault (MVP)MVP Sunday, October 30, 2016 1:44 PM
- Marked as answer by DeanJW2006 Monday, October 31, 2016 8:17 PM
Sunday, October 30, 2016 12:46 PM -
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
- Edited by Daniel Pineault (MVP)MVP Sunday, October 30, 2016 1:44 PM
- Marked as answer by DeanJW2006 Monday, October 31, 2016 8:17 PM
Sunday, October 30, 2016 12:46 PM -
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