• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » How to Recover Corrupt Access Forms using SaveAsText / LoadFromText

How to Recover Corrupt Access Forms using SaveAsText / LoadFromText

February 20, 2013

Improper usage of MS Access database often corrupts its objects like reports, forms, tables, queries, macros, and modules. However, you do not get to know about small corruption issues as Access automatically corrects them; but, if it fails to resolve the corruption, then it either throws an error message or exhibits some unexpected behaviors. You get an error message while updating, deleting, or accessing records, or while running queries, forms, and reports. For handling such situations, Access provides some commands that you can use manually; but, if these manual methods too become unable to fix the issue, then use of an efficient Access database repair software is recommended. One of the undocumented and hidden commands for recovering your data when the forms or reports of your MS Access database get corrupt is SaveAsText / LoadFromText. Using this command, you can export your data to text file and instruct MS Access to recreate it from this text file. Mentioned below are the steps to recover corrupt Access forms and reports.

How to Recover Corrupt Access Forms and Reports

How to Recover Corrupt Access Forms and Reports

1. First of all before working on your database, it is recommended to make its backup.

2. Look through the modules by opening the code window by pressing CTRL+G. If there is module in this form or report and you can see it, then copy its text on a Notepad, and then save it.

3. Now open the immediate window by pressing CTRL+G and export form or report as text file. Type the below mentioned command:

“SaveAsText acForm, “Form1”, “C:MyFolderForm1.txt””

Replace the Form1 with the name of your form and your directory with MyFolder. However, if you have issue with your report, then replace acForm with acReport.

ALSO READ:  How to Create a Survey Using Google Forms

4. Make sure that the text file that you have created is stored at your specified folder.

5. Now delete the corrupt form from the database by going through the navigation pane (in Access 2007 or later) or database window (in previous versions of Access), and then press ‘Delete’.

6. After that compact your database:

a. To compact your database in Access 2010 use ‘Compact and Repair Database’ option available at ‘Database Tools’ on the ribbon.

b. To compact your database in Access 2007, go to Office button, click ‘Manage >> Compact’.

c. To compact your database in Access 95 – 2003, go to ‘Tools >>Database Utilities >> Compact’.

7. Once again open the immediate window by pressing CTRL+G, and enter the below mentioned text:

“LoadFromText acForm, “Form1”, “C:MyFolderForm1.txt””

Like wise as you replaced ‘Form 1’ in step 3 with the name of your form replace it here as well and replace all the other fields likewise as you did in step 3.

If Access cannot make any sense for the form to export, then you may receive an error message at step 3. In such case, you have to delete and recreate the form, which can be possible if you have saved the code in step 2. Therefore, if step 3 works fine without any error, then there are good chance for the success of rest of the steps as well.

However, if this command fails to do any needful for you, then use of professional Access database recovery software is recommended. These tools repair corrupt forms, reports, and all other database objects and restore your entire database.

Tweet
Share1
WhatsApp
Pin1
Buffer
2 Shares

Filed Under: How To Tagged With: forms

You May Also Like

How to Create a Survey Using Google Forms
Tips to Boost Your Ranking and Sales on Etsy - TATFI
5 Ways to Boost Your Ranking and Sales on Etsy
DevOps Model Explained - TATFI
The Complete Guide to DevOps: How the Model Works and Who It Benefits

About Adam George

Adam Gorge is an expert handler of Access Database errors, Access database corruption issues etc. He has written many articles on Third Party Access Database Repair Software, Access database corruption issues, Compact/repair utility etc. You can contact him at adam.gorge507@gmail.com

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Best e Readers to Buy in 2023 - TATFI

5 Best eReaders to Buy in 2023

Amazfit Falcon Smartwatch - TATFI

The Amazfit Falcon is a Military Grade Smartwatch with Premium Looks and Great Features

Couchmaster Cyboss Ergonomic Couch Desk - TATFI

Couchmaster Cyboss is an Ergonomic Desk to Keep Off Neck Pain

Philips Hue Festavia String Lights - TATFI

Add a Bit of Sparkle to Your Christmas Tree with Philips Hue Festavia String Lights

Samsung Galaxy Tab A7 Lite Kids Edition - TATFI

This Kid Friendly Tablet from AT&T is a Thoughtful Gift for Your Little One This Christmas

Is An iPhone Really Worth It - TATFI

Is an iPhone is Really Worth It?

Devices You Might Want to Try - TATFI

4 Fantastic Devices You Might Want to Try

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Samsung Galaxy S10 Unlocked - TATFI

The Samsung Galaxy S10 Unlocked– Your Key to Total Freedom

Make Money Playing at Fairspin Online Casino - TATFI

Make Money Playing at Fairspin Online Casino

How Mobile Wellbeing Apps are Empowering Patients - TATFI

How Mobile Wellbeing Apps are Empowering Patients

Tips to Boost Your Ranking and Sales on Etsy - TATFI

5 Ways to Boost Your Ranking and Sales on Etsy

PunchBee Time Management App - TATFI

Know How You Spend Your Time with PunchBee

DevOps Model Explained - TATFI

The Complete Guide to DevOps: How the Model Works and Who It Benefits

Approaches to Digital Marketing - TATFI

Blending Technical and Content-Centric Approaches to Digital Marketing

Tech Tips For Startups - TATFI

Useful Tech Tips For Startups

Boox Tab X Android eReader - TATFI

Boox Tab X is an Android eReader That Helps You Do More Than Just Read

Best Translation Apps for Android - TATFI

5 Great Translation Apps for Android

Dynamic Island Feature on Your Android - TATFI

How to Get the Dynamic Island Feature on Android

Connected TV Advertising In 2023 - TATFI

5 Things You Need To Know About Connected TV Advertising In 2023

TheAppTimes © 2023 // Runs on StudioPress