Author Options:

The Microsoft JET Database Engine could not find the input table or query? Answered

I have a strange problem which suddenly appeared in my Access database. .mdb file involve tables, forms and reports and a code. Of course it splitted into two different files. From time to time i make any changes in them and everything was perfect. BUT recently these files damaged. I started get a rubbish in my table field first, and pops up an error message while trying open any form or report after. The error is: The Microsoft JET Database Engine could not find the input table or query '<Table or Query Name>'. I am sure it exists and the name is spelled correctly. What is the problem and how can i solve it?


The forums are retiring in 2021 and are now closed for new topics and comments.

Best Answer 6 years ago

Sounds very
familiar...try to turn off AutoCorrect under the Tools menu. It might help.
Also run Compact and Repair, or Jet Compact Utility as you wish. Both these
features created by officials, but Jet is better a little bit i heard.

Also try to find more information on other forums, where your
issue is described. http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1435-access-database-2003-became-corrupt-after-power-outage-what-gives

e.g. the first I have googled. At any rate good luck.


Answer 6 years ago

may i inquire, what do you mean? PROBABLY you have an answer on the subject matter?