How to change Pivot Table external data source (MS Access Database)by VBA

Discussion in 'Access VBA Modules' started by John Chi, Jun 10, 2012.

  1. John Chi

    John Chi Guest

    Dear all,

    I have several pivot tables linked to a MS Access Database. And currently the MS Access Database has moved location, How can I update the link to MS Access Database by VBA?

    Thanks very much!
     
    John Chi, Jun 10, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. BMunny
    Replies:
    1
    Views:
    130
    david epsom dot com dot au
    Sep 29, 2003
  2. nico

    alter table in external database: possible?

    nico, May 11, 2004, in forum: Access VBA Modules
    Replies:
    2
    Views:
    174
    Tim Ferguson
    May 11, 2004
  3. Sergey Poberezovskiy

    Running queries with VBA functions in external database

    Sergey Poberezovskiy, Aug 11, 2004, in forum: Access VBA Modules
    Replies:
    2
    Views:
    128
    Sergey Poberezovskiy
    Aug 11, 2004
  4. Sergey Poberezovskiy

    Running queries with VBA functions in external database

    Sergey Poberezovskiy, Aug 15, 2004, in forum: Access VBA Modules
    Replies:
    7
    Views:
    302
    david epsom dot com dot au
    Aug 18, 2004
  5. Jerry Mc Cauley

    Pulling Data from external table in another MS Access database

    Jerry Mc Cauley, Jun 4, 2006, in forum: Access VBA Modules
    Replies:
    8
    Views:
    162
    Douglas J Steele
    Jun 7, 2006
  6. Anthony

    change external database properties programatically

    Anthony, Jan 8, 2007, in forum: Access VBA Modules
    Replies:
    5
    Views:
    148
    Van T. Dinh
    Jan 8, 2007
  7. Replies:
    1
    Views:
    115
    Eric Blitzer
    Feb 21, 2007
  8. dalbin

    Change a linked table to a local table (External)

    dalbin, Mar 28, 2007, in forum: Access VBA Modules
    Replies:
    6
    Views:
    239
    Douglas J. Steele
    Apr 2, 2007
Loading...