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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. BMunny
    Replies:
    1
    Views:
    98
    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:
    121
    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:
    96
    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:
    243
    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:
    137
    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:
    108
    Van T. Dinh
    Jan 8, 2007
  7. Replies:
    1
    Views:
    87
    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:
    211
    Douglas J. Steele
    Apr 2, 2007
Loading...