407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 5999)

Database - The Microsoft Jet Database cannot find the input table or Query MsysTables

This information applies to :

Article ID
5999

Created/Updated
July 23, 2019

Category
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 'MsysTables'

Cause:
1. You have been using QuoteWerks for a long time and have never run database maintenance on the DOCS.MDB file.

2. You ran maintenance while another user was trying to access the QuoteWerks database. This can be via QuoteWerks or an external application such as a reporting Tool.

3. There was a network issue that caused corruption while the table was being accessed by QuoteWerks.

Solution:
1. Try restoring from a previous backup of the DOCS.MDB file.

2. Use the Medic Utility to Restore a backup of the DOCS.MDB file. This can be accessed from the Start Menu-Programs -> QuoteWerks -> Tools and Information -> Medic Utility. Then, select the Utilities-Restore from Backup Menu.

3. As a last resort, you can try running Maintenance on the DOCS.MDB file from the Medic Utility.

If this does not resolve the issue, please contact Quotewerks Technical Support at 407-248-1481 or support@quotewerks.com


New Search