View Single Post
 
Old 08-30-2019, 12:17 PM
PLSBRYDOBOY PLSBRYDOBOY is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2019
Posts: 1
PLSBRYDOBOY is on a distinguished road
Post Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error

Hi all,

I have an excel application that we use to refresh data through SQL. Had been running essentially no problems at all until yesterday. For example, we can refresh up to 24 months worth of sales data for 6 different divisions, and I was able to have that happen with no issues. Without explanation, the timeframe that I could refresh suddenly started decreasing. First down to 18 months, then 12, the Year to Date, until now I can't even try 5 days worth of data for a single division without excel throwing Err 1004, "General ODBC Error". I am able to take the exact query excel is attempting to use, and execute it in a query window. Any help appreciated thank you
Reply With Quote