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 below command on VB Demo 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 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).