Microsoft Office Forums Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-30-2019, 12:17 PM
PLSBRYDOBOY PLSBRYDOBOY is offline Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error Windows 10 Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error Office 2016
Novice
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error
 
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
Reply

Tags
refresh, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error Error 1004 on EnvelopeVisable mamies Excel Programming 4 03-01-2017 05:14 PM
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error Excel 2010 Chart SetSourceData 1004 error pocerus Excel Programming 4 10-26-2014 08:10 AM
Run Time Error '1004' galkej Excel 0 02-03-2014 06:39 AM
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error Run time error 1004 yonasan Excel Programming 3 06-12-2012 11:08 PM
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error runtime error 1004 gbaker Excel Programming 11 06-06-2012 05:23 AM


All times are GMT -7. The time now is 11:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft