Group: microsoft.public.access.gettingstarted
From: "bbxrider"
Date: Tuesday, October 23, 2007 9:21 AM
Subject: Re: edit/change external links

ok see that now, thanks
bob
"Arvin Meyer [MVP]" wrote in message
news:ukQNGvQFIHA.4028@TK2MSFTNGP05.phx.gbl...
> The easiest way to handle this is to delete the table links, compact the
> database, and recreate the links.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "bbxrider" wrote in message
> news:Oaxq7qQFIHA.4880@TK2MSFTNGP03.phx.gbl...
>>i have a access 2000 mdb (that i'm converting to 2003) that is just
>>reports with external links to all the 'data' mdb's from another
>>installation
>> the links are to various machines on the other/old installation eg:
>> \\someServer\c\somedir\anAccessfile.mdb
>> so when i try to open the report, query, etc i get an error that it can't
>> find the linked file
>> (... is not valid path. make sure the path name is spelled correctly and
>> you are connected to the server......)
>> i have the db's or shells of them that i can put on my new lan or pc, etc
>> if i can just edit that link value, then i can put the files easily where
>> i want on my new lan, or pc, etc
>> i suppose i can put up a temp machine named someServer with the dir's etc
>> so to actually duplicate the link value
>> but i'm to trying to save doing that work
>> so i was hoping there is some way to edit all those links
>> bob
>>
>
>


Safety Articles | News in English | 20lbs in 30 days | Bluegrass | Usenet Newsfeeds