QuoteWerks Knowledgebase Topic (Article ID 5999)
Database - The Microsoft Jet Database cannot find the input table or Query MsysTables
This information applies to :
July 23, 2019
Error Opening recordset in ConnOpenRecordset():
Error(-2147217865) The Microsoft Jet Database cannot find the input table or Query 'MsysTables'
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.
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 firstname.lastname@example.org
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)