407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6608)

Product Database - "The Microsoft Jet Database cannot find the input table"

This information applies to :

Article ID
6608

Created/Updated
April 22, 2015

Category
Product Database


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:

Error Opening recordset in ConnOpenRecordset():
Error(-2147217865) The Microsoft Jet Database cannot find the input table or Query 'TableName'

Cause:

Either dashes or underscores are present in the table name (usually related to product databases.)

Solution:

Remove the dashes and the underscores.

or

While adding a custom SQL Query i am getting an error "Query : - Got Invalid object name"

Reason1 : The table name mentioned in the query is wrong
Solution : Verify the sql table names mentioned in the query. Also execute the query in SQL Server Management Studio and check if you are able to get the output

Reason2 : Database name and schema name are not mentioned in along with table name
Solution : Mention the database name and schema name along with the table names in the SQL query. For ex: select * from MESQLDBM.dbo.Alert

New Search