CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:
  • Microsoft Access Database Engine error '80040e37' The Microsoft Access database engine cannot find the input table or query 'Vidss'. Make sure it exists and that its name is spelled correctly.

  • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    142
  • Date Created
    Monday, July 11, 2011
  • This Article Has been Viewed
    2524 times
  • Short Desc
    The Microsoft Access database engine cannot find the input table or query 'Vidss'. Make sure it exists and that its name is spelled correctly.
  • Details
    If your table name is mis-spelled, you will recieve the following error.

     

    Microsoft Access Database Engine error '80040e37'
    The Microsoft Access database engine cannot find the input table or query 'Vidss'. Make sure it exists and that its name is spelled correctly.
    /NewInsert.asp, line 109
  • Recreate Issue
    To recreate this issue:

    <%
    sql.commandtext="select column1 from Vidss"
    %>

    The abose Table is incorrect, either by spelling or by name itself.
  • Resolve Issue
    To resolve this issue.

    <%
    sql.commandtext="select column1 from Vids"
    %>


    As you can see, we removed one of the "s" from the table name.
    Make sure that the name of your database Table is correctly spelled.