excel macro runtime error 1004 general odbc error Concan Texas

Pc Repair Services, Website Design And Hosting, Graphics Services

Address PO Box 187, Vanderpool, TX 78885
Phone (830) 966-2410
Website Link http://riverpc.com
Hours

excel macro runtime error 1004 general odbc error Concan, Texas

Is there something wrong in my format that didn't show up during double digit months? The real strange thing is why it does not work on my machine, but on the guys next to me it does? All times are GMT -5. I always edit recorded macros eliminating the unecessary items and replace SELECTION with absolute cell references. "CLR" wrote: > Hi Joel......... > Well, you saved the day, or week, or several

ronaksinghwadhwa, Jul 10, 2013 #8 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? As each line adds, it gets exponentially more demanding. no problem. Near Earth vs Newtonian gravitational potential How should I interpret "English is poor" review when I used a language check service before submission?

How would they learn astronomy, those who don't see the stars? Results 1 to 6 of 6 Thread: [RESOLVED] General ODBC error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded me = nerd here.. –peege Nov 27 '14 at 17:01 add a comment| up vote 0 down vote The error went away after a computer reset. We have checked that we have the same connections (Data Sources).

Using Java's Stream.reduce() to calculate sum of powers gives unexpected result Is "halfly" a word? (KevinC's) Triangular DeciDigits Sequence more hot questions question feed lang-vb about us tour help blog chat Can an ATCo refuse to give service to an aircraft based on moral grounds? Advertisements Latest Threads WCG Stats Saturday 15 October 2016 WCG Stats posted Oct 15, 2016 at 8:00 AM Review round up - 14 October 2016 Becky posted Oct 14, 2016 at For anyone reading I have been told to attempt to clear the cache in the script.

Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. Howewver yes the problem remains. Why are so many metros underground? Jan 31 '08 #4 reply Expert 5K+ P: 8,435 Killer42 Just on the date theme, it might be worth checking whether both PCs have the same settings for date format.

How can I get it to keep from being changed? Stay logged in Welcome to PC Review! It might be useful to know which one is the "exception". Also check that the network connection...if the file is found over a network..

Thank you for your help. > On Friday, November 07, 2008 9:38 AM CL wrote: > Hi All......... > I have a little macro that queries an ACCESS file and returns The Refresh method causes Microsoft Excel to connect to the data source of the QueryTable object, execute the SQL query, and return data to the range that is based on the Meaning of S. PaulO View Public Profile Find More Posts by PaulO

« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes

Jan 31 '08 #1 Post Reply Share this Question 5 Replies 100+ P: 491 daniel aristidou Since he said it might be date...which is possible have you checked you computer date When i click on the shortcut, I get an error pop up: Run time error 1004' General ODBC error. The "from" and "to" date fields I added ( I think I'm correct). The program works fine on my computer, but when my user > >> > > tries to run > >> > > it on his computer, (same versoion of Excel, 2000),

How to deal with players rejecting the question premise House of Santa Claus Logical fallacy: X is bad, Y is worse, thus X is not bad What advantages does Monero offer The machines with Excel 2007 only have "SQL Server". I reopened the query from the cell and I did get results back after closing the MSQuery box. TH How to calculate time to empty Cyberpunk story: Black samurai, skateboarding courier, Mafia selling pizza and Sumerian goddess as a computer virus When must I use #!/bin/bash and when #!/bin/sh?

Skip,Just traded in my old subtlety...for a NUANCE! more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed go to VBA menu Tools - Options - General - Error Trapping. "CLR" wrote: > Hi All......... > I have a little macro that queries an ACCESS file and returns desired By joining you are opting in to receive e-mail.

Once the query is built and downloaded, hop into VBE, go to immediate window and type: print mysheet.querytables(0).connection and same for Command and whatever else you need. I'd hoped it was a coding error on my part that involved the year change, but if it is, I can't see it. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Going to be away for 4 months, should we turn off the refrigerator or leave it on with water inside?

I've googled the error and it seems to mention an awful lot that there could be a problem with the link but I'm very inexperienced with Access and not quite sure Thanks for the comeback..... because i'm having the same issue and can't find the reason why it doesn't store the "SERVER" parameter.. COde:: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 10/07/2013 by wadhwra ' ' With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=I:\Sharepoint MIS\Misc\New Microsoft Office Access Application (2).mdb;DefaultDir=I:\Sharepoint MIS\" _ ), Array("Misc;DriverId=25;FIL=MS

Even though initial connection string is valid, and the refresh is successful, the connection string is still being modified after the first refresh, and subsequent refresh's prompt me for Server info! The program works fine on my computer, but when my user tries to run > > it on his computer, (same versoion of Excel, 2000), he gets the following > > This time I got the above string 5 times.