excel vba general odbc error Dawson Texas

Address 5935 NW County Road 2260, Barry, TX 75102
Phone (903) 851-9113
Website Link
Hours

excel vba general odbc error Dawson, Texas

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 Even the guy (not myself) who wrote the code can't figure out why it is not working. I would try changing up the date ranges and see if it still works. 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

Sign up now! I checked both ofb these and they are fine. Microsoft Customer Support Microsoft Community Forums Dev Shed Forums Navigation Forums Tools Newsletter Signup Articles Help Devshed Network Developer Shed ASP Free Dev Shed Dev Articles Dev Hardware Tutorialized SEO Chat 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

because i'm having the same issue and can't find the reason why it doesn't store the "SERVER" parameter.. I've started from the beginning again. Not the answer you're looking for? About an hour ago, before I got ticked and tried more solutions I was able to see that the query itself was present in the cells on Sheet1.

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. You will see your connection string and SQL. Do I need to change the connection string structure for 2007, or is there another issue at work? Close Box Join Tek-Tips Today!

Share it with others Like this thread? Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate Well, you saved the day, or week, or several weeks that I've been working on that problem........just as you suggested, I removed everything from the macro that I could and have Sign Up Now!

By default, when you access the ODBC manager, you are using the 64 bit manager. By default, when you access the ODBC manager, you are using the 64 bit manager. What is a type system? "Rollbacked" or "rolled back" the edit? It is the refresh that is causing the problem. –lance Apr 22 '13 at 16:37 Sorry I meant just .Refresh without using the BackgroundQuery:=False. –AxGryndr Apr 22 '13 at

Strings? Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. I have very little knowledge about program and languages. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

The default is some type of table layout which is only good for bringing back the entire table. Is there a role with more responsibility? (KevinC's) Triangular DeciDigits Sequence What emergency gear and tools should I keep in my vehicle? When I step through the code, it fails at the Refresh line and throws a run time error '1004' - General ODBC error (very descriptive, I know). Thanks Reply With Quote Jan 4th, 2011,01:57 PM #2 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif.

Thanks RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 19:04 The string you copiedODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=PowerThe string in your codeODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=Power;Network=DBMSSOCN;Address=111.11.221.70,1433So if what you say is true, then Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. The Excel file has multiple macros. Thanks for the help Daniel.

How to handle a senior developer diva who seems unaware that his skills are obsolete? With ODBC, the best thing is to start as simply (a simple read) as you can, and add pieces until it breaks. What is missing from it? I replaced it and I'm back in business.

Go to the regional settings in the control panel and check the date formats Feb 1 '08 #6 reply Message Cancel Changes Post your reply Join Now >> Sign in Selection.QueryTable.Refresh BackgroundQuery:=False Does this tell you something? The difference is that on 64 bit systems, all the library files and drivers in the "%SystemRoot%\system32\" directory are 64 bit. Fortunately, we do some of that work ourselves.

Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. One thing to check is > the error option in BA. I ran it, took the string returned and copied and pasted it into my code.Here is the returned stringODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=PowerI copied it into my code like this Sheets("DataQuery").Selectreportdate = ActiveSheet.Range("B1").ValueRange("A3").SelectWith Selection.QueryTable.Connection I also started avoiding DSNs since I have users who like name their connections something completely different.

I used SET NOCOUNT ON; It worked! One thing to check is > > the error option in BA. How should I interpret "English is poor" review when I used a language check service before submission? I would > > remove some unecessary line in the command until you get it to work. > > First > > try on the working computer to eliminate as many