Fix Error Type:Microsoft JET Database Engine (0x80040E37)
Posted on 2004-10-19
When trying to open one of my pages on my test server the following error appears:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'ObserverMiscellaneous'. Make sure it exists and that its name is spelled correctly.
/staffarea/ObserverMisc_Querylist.asp, line 253
I assume it means that the page is looking for a table or query called 'ObserverMiscellaneous'.
The problem is that there isn't a table or query called 'ObserverMiscellaneous' or any reference to it in the code. The tables and queries are called 'ObserverMisc'. Originally there was a table called 'ObserverMiscellaneous' in the Access database but I changed it's name and all references to it in the asp to 'ObserverMisc'.
I thought that I may have accidently left something unchanged but I have searched endlessly through the code of all of the pages linked to this page and everything looks right.
Can anyone tell me where I am going wrong or why the page is trying to find that table???