H
Hobie
Dear All,
My Excel worksheet contains many queries to a single Access-MDB-file.
When I send the worksheet and the database to a colleague in another
network Excel can't update the queries any more because it doesn't
find the Access file. Obviously Excel stores the links to the Access
file as absolute paths (like "X:\something\database.mdb").
How can I change alle the links to the Access file without creating
every query again? Is it possible to store relative links to the
Access file instead of absolute links?
Unfortunately the Edit->Links tools does not work for database
connections.
Many thanks for your help!
Kind regards,
Hobie
My Excel worksheet contains many queries to a single Access-MDB-file.
When I send the worksheet and the database to a colleague in another
network Excel can't update the queries any more because it doesn't
find the Access file. Obviously Excel stores the links to the Access
file as absolute paths (like "X:\something\database.mdb").
How can I change alle the links to the Access file without creating
every query again? Is it possible to store relative links to the
Access file instead of absolute links?
Unfortunately the Edit->Links tools does not work for database
connections.
Many thanks for your help!
Kind regards,
Hobie