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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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

Please log in to comment
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

Please log in to comment
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

Please log in to comment
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

Please log in to comment
Answer this question or Comment on this question for clarity