Sage 100

Myth or Reality? I am looking for an example report that exemplifies the much touted performance advantage that MS Access style Pass Through Queries provided for MAS90. However, I have looked at several from others, created several myself and searched the Community, but my testing doesn't support the ""rumored"" advantage. I've already reached out to the biggest proponents that I know, but I have yet to find evidence. Does anyone have one of these rare gems to share? I'll publish the results if I find one. #crystalreports, #crystal_report

I have one if you want to put a stop watch to it. In my experience, it is 10X faster...

Also in MS Access the ODBC timeout setting effects the response time on ODBC calls without a PTQ. PTQ are faster since they are processed at the server. See attached MS article on advantages and disadvantages: https://support.microsoft.com/en-us/kb/128808

@MoiraGoggin Can you tell me more about how ODBC timeout setting effects response time? Regarding PTQ being faster, are you talking about Premium or C/S ODBC? The ODBC in Advanced as well as Standard is client based thus the MS article wouldn't apply.

See Access Options Advanced for ODBC settings time outs and retries. The article may be old but it still covers some good information. Also, if you want to learn more about optimization with SQL see this article: https://technet.microsoft.com/en-us/library/bb188204%28v=sql.90%29.aspx

Thank you @MoiraGoggin for the interesting article on SQL Server/MS Access connections. I am still looking for anyone to send me a sample Crystal report that demonstrates a performance improvement using MS Access pass through queries over the direct use of SOTAMAS90 **in either Sage 100 Advanced or Standard**. TIA