/build/static/layout/Breadcrumb_cap_w.png

Software Question


Access 2010 file corrupt. Gibberish in the table

02/24/2015 2365 views
I have an .mdb file that consists of code, tables, reports and forms. This .mdb is splitted into a front end and back end. Sometimes I need make any alterations in it, but always was no problem with it, until recently. One day I saw a gibberish in the table and if I am trying to open a form or a report pops up an error: The Microsoft JET Database Engine could not find the input table or query “Table or Query Name”. I am confused. How do I restore my file except recovering from a backup?
Answer Summary:
0 Comments   [ + ] Show comments

Comments


All Answers

1

>Sometimes I need make any alterations in it,
>except recovering from a backup?

You set about altering a database without first saving a safety copy somewhere? Sorry, chum, but only a fool would do that. I'll bet your machine back-up cycle runs along the lines of "I'll do that tomorrow."

You could try any of the myriad tools out there that claim to repair databases but, before running any of them...can you guess what my suggestion is going to be?

Answered 02/25/2015 by: VBScab
Red Belt

1

The causeof your issue is AutoCorrect, I am quite sure. Microsoft creates this featurefor help with renaming, but it mostly bugged than useful as a result. Turningoff this option must help in case. But first make a new db blank, then go toTools/Options/Current Database - turn off AutoCorrect check boxes and add allthe data into a new created blank. That`s it. And you should do this every timeyou are going to create a new database unfortunately.

Also Iadvise to set minimal references and compile from debug menu.

And if youstill unable to handle the problem, then all the tech forums are waiting foryou :D jokes aside, try to find some forum threads related with such issue, forexample: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1435-access-database-2003-became-corrupt-after-power-outage-what-gives

there canbe an interesting information for you. 

Answered 02/27/2015 by: DuchessAvice
White Belt

0

 If you don't want to restore the datafrom backup recover the corrupt or damaged Access database via Access Repair Tool.When I faced the corruption issue I was very disappointed by thanks to myfriend she recommended to me to use a third party tool.

http://msaccess.filerepairtool.net/
Answered 11/12/2015 by: alva114
White Belt

This content is currently hidden from public view.
Reason: Member has been banned from the site For more information, visit our FAQ's.
0
Accept that the file is hosed and revert to the backup. Life is too short to waste time on this. Make sure you have a backup before any edit operation and you are safe from whatever factor caused this corruption.
Answered 02/26/2015 by: EdT
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ