Portal Home > Knowledgebase > Windows Hosting > Database > MSACCESS > error:Microsoft OLE DB Provider for ODBC Drivers error '80040e37'


error:Microsoft OLE DB Provider for ODBC Drivers error '80040e37'




Problem:

error:Microsoft OLE DB Provider for ODBC Drivers error '80040e37'



Solution:

Problem:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query. Make sure it exists and that its name is spelled correctly.

Solution:

This issue occurs when you are calling an incorrect table name. Check to make sure that the table name is spelled correctly in the .Open 'Select? statement of your code. Also make sure in the .Open statement that you are calling the table name and not the DSN name if the two are different.

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read