Knowledgebase
[QODBC-Desktop] Troubleshooting - MS Access Crashes Hard On Date Query
Posted by Jack - QODBC Support on 16 December 2014 10:19 AM

Troubleshooting - MS Access Crashes Hard On Date Query

Problem Description:

I've linked all the QODBC tables into an Access 2010 DB. I have created table subset queries on the original tables and would like to do selects based on date ranges - other things too, like JOINs - but I'm stuck with this problem. The minute I give Access a date constraint like ReceivePayment.TxnDate >=#11/1/2014# as stated in your "How Dates Are Formatted.." documentation for Access Date formats, Access immediately crashes. No msgs in the brief QODBC log files about the crashes as best I can tell:

Solutions:

Please try executing the following command using QODBC Test Tool to see if it can solve the issue: sp_optimizefullsync ALL

This command will bring some data to a local cache to increase retrieval performance for queries. I would like to suggest you to please let run above command completely. Above command may take sometime depends on your records in QuickBooks. It may take 2-24 hours or more depends on the number of records in the QuickBooks company file. Please let this command run completely. Do not kill this command. It is not advisable to kill/close the application while its building the Optimizer file.

After successfully execution of the above command, please create new MS Access Database file & link all tables & execute the query again. It should work without any issue.

Please refer: How to Use QODBC with Microsoft Access 2010

 
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).