407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
Customer Area

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 24.0 Build 2
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

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)