How to fix the "Microsoft Jet database engine cannot find the input table" message
Sample Error
You may see a message like "Microsoft OLE DB Provider for ODBC Drivers error '80040e37'"
Or... "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'setup'. Make sure it exists and that its name is spelled correctly"
includes/functions.asp, line 19
Or... "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'setup'. Make sure it exists and that its name is spelled correctly"
includes/functions.asp, line 19
Solution or Workaround
This error can occur in PDshopo if you have not formatted your database, or the database is blank. Run the database format procedure, located at:
yourstore.com/admin/dbsetup.asp
OR
yourstore.com/admin/dbsetup.aspx
Before running this procedure, be sure to backup your database by downloading a copy from your web server. This procedure will update the database tables and field structure (it will modify the table columns if needed, but it will not delete your data).
yourstore.com/admin/dbsetup.asp
OR
yourstore.com/admin/dbsetup.aspx
Before running this procedure, be sure to backup your database by downloading a copy from your web server. This procedure will update the database tables and field structure (it will modify the table columns if needed, but it will not delete your data).
Related Articles
Related Topics
Article Applies to:
PDshopPro / Standard, PDshop Plus, PDshop Advanced, PDshop .NET
Search for help...