Recovering Forms - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Recovering Forms

Mark Kaply

4 years ago

Well, I did a silly thing... my database became very corrupted. I have a "clean" copy in Excel so I DELETED my current Access database and recreated it using the Excel copy.
However, I did not realize (I guess) that deleting the database would delete my associated forms as well. So... is there any way I can recover the forms that I had built ??

	Adam Schwanz @Reply 4 years ago
This is why backing up is CRITICAL. I hope you didn't lose much. You may be able to restore the file from a system restore. If it's permanently deleted though there is no getting it back, unless you have a backup.

	Scott Axton @Reply 4 years ago
If it is in your trash you might be able to restore it. Then create a new blank DB and try to import your tables and forms. If you don't know how to import them let us know and we / I can walk you through it.

	Mark Kaply OP @Reply 4 years ago
I do still have the *.accdb file in my trash. The table itself is essentially trash however I was hoping I could "recover" the associated forms. I know that I can recreate the forms however time is becoming a factor on this project. If there is something we can try, any help would be GREATLY APPRECIATED.

	Scott Axton @Reply 4 years ago
Just create a new folder. Restore that db to that folder from the trash. Open Access and create a new empty db in the same folder. See screencap. Find and select you "bad" db.

	Scott Axton @Reply 4 years ago

	Scott Axton @Reply 4 years ago

	Scott Axton @Reply 4 years ago
If the data is still corrupt you may be able to design the table then copy and paste the fields into a new table. Should save you some work any way. You didn't say why you believe that the data is corrupted. If the data itself is bad but the tables are not corrupt you should be able to just open the tables and delete just the data.

	Scott Axton @Reply 4 years ago
In the future if you have issues see the Troubleshooter before you do drastic stuff. AND as Adam mentioned above BACKUP your Database regularly. Especially before making big changes.

	Richard Rost @Reply 4 years ago
Backup nightly!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View