122Views2Replies

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?

3 Replies

user
SwatrebandBest Answer (author)2015-02-28

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.

Select as Best AnswerUndo Best Answer

user
steveastrouk (author)2015-02-23

Probably spam in your tables.

Select as Best AnswerUndo Best Answer

user

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

Select as Best AnswerUndo Best Answer