SQL fails without breakpoint
Hi,
maybe you should retrieve your data using ADO instead: http://support.microsoft.com/default...b;EN-US;246335 arno Adding a breakpoint to VBA code and using F8 to step through the code produces desired results. Without the breakpoint the program fails. I traced the problem to a worksheet which is not filled in from an SQL query earlier in the code... the worksheet displays "External Data_1: getting data..." instead of having valid data from a query. |
SQL fails without breakpoint
Hi,
.Refresh BackgroundQuery:=True I do not know if this applies here, however, I had trouble with big data amounts when I turned on "background" in ODBC-Databases with FoxPro. I got very misleading errors. So, I would suggest that you test your queries with lots of records as result. If everything is ok then fine! regards arno |
All times are GMT +1. The time now is 12:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com