Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Duesseldorf, Germany
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    External data from Access & relocation of database (Office 97)

    I use external data in Excel from access via the Access ODBC Driver. When the source database is relocated, Excel cannot find the database anymore as it stores the absolute path. Changing the ODBC source doesn't help therefore.
    Is the a workaround? Has this behaviour changed in Office XP?

  2. #2
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: External data from Access & relocation of database (Office 97)

    This is a toughie. I had the same problem and had to write a macro to re-do the path. The easiest way is to record a macro as you set it up and then examine it for the details that you want to change. Put it the new path and use the macro to edit the connection.

    There are two path type connections (from memory), one that deals with the location of the file and one that deals with the name of the file (includes the path for some reason!!).

    I have no idea about Office XP - sorry.

    Tim
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •