in
All Tags » VBA » odbc (RSS)

Browse by Tags

  • Access VBA ODBC Connection

    Hi I have an Access database and want to create an ODBC connection to it. What is the easiest way to do this? I have never done one before
    Posted to Access (Forum) by microsoft on 01-26-2010

  • How do you create ODBC in VBA to retrieve a text file from remote server then populate access table?

    How would you do the same thing as below, but just retrieving a text file from a remote (ftp)server on our network so I can populate a table in my access database? I need to do this in VBA. Linking tables on remote servers with local odbc does not work in Access. Rank: Genius Arthur_Wood:Dim conn as...
    Posted to Access (Forum) by microsoft on 01-13-2010

  • ODBC and VBA

    I have a working functioning MySql Server setup, and I get no connection errors. So how for I access my records now that I am connected. The Method I am using doesn't seem to work. Dim NewWS As Workspace Dim NewCon As Connection Dim TestRs As Recordset Dim SqlSt As String Set NewWS = CreateWorkspace...
    Posted to Access (Forum) by microsoft on 12-20-2009

  • Create an odbc link using vba!!

    Hi All, In Access, do you know how to create an odbc link using vba? Trying to avoid having to setup odbc links on everyone's computer so they can use sql server tables. Note: don't want to use linked tables for this one. Thanks, Marc
    Posted to Access (Forum) by microsoft on 12-07-2009

  • ODBC linked tables saved password requiring password

    I have 2 linked tables in Access 2000 to a SQL Server. I saved the password when linking through the automated process that Access has (I didn't do it via VBA). I can open the tables and close the tables without issue and without restriction. If upon entry to the database, I do not open a table,...
    Posted to Access (Forum) by microsoft on 08-26-2009

  • Excel link with Access database via ODBC and VBA macro will not work.

    Hi, I am working through Microsoft Knowledge Base Article 213772 "How to Use System, User, and File Data Sources" It describes how to use an Excel VBA Macro to link up (via ODBC) to the MS Access sample database Northwind.mdb My VBA code is as follows: Sub Get_Data() 'Define SQL query string...
    Posted to Excel (Forum) by microsoft on 08-17-2009

  • SQL - ODBC - VBA in Excel - Run-time error '1004'

    Hi, I built a code that executes an SQL code over an ODCB connection. My problem is that this code is working well on my computer but isn't working on 6 others similar computer that I tried my code. Error message : Run-Time Error '1004'; Application-defined or object-defined error. This appear...
    Posted to Excel (Forum) by microsoft on 08-13-2009

  • ODBC connection with VBA

    Hello! Can anyone tell me how can I Connect (link) to other databases table with VBA? I want to link an Oracle database tables to access and make some queries. There are over 40 tables so I don't want to make any fixed linking. (File -> Get External data -> Link tables) So have anyone any suggestions...
    Posted to Access (Forum) by microsoft on 07-30-2009

  • Link a table via ODBC in VBA

    Simple question which I have done in the past yet cannot find help on how to do it. I know that I use a connect method, but cannot rememeber or find anywhere sample code to do this. I need to in VBA code create a linked table, using a DSN. I want the table to be linked and seen as a table in the tables...
    Posted to Access (Forum) by microsoft on 07-15-2009

  • Make Table Query and Quickbooks ODBC

    I have a simple Make Table query. The query comes from a table in Quickbooks that is linked by QODBC, which is Quickbooks version to link in Access. There is no problems with how Access makes the table. The issue is that the link in really slow. Quickbooks acknowledges this problem. In other words it's...
    Posted to Access (Forum) by microsoft on 07-08-2009
Page 1 of 2 (12 items) 1 2 Next >