RefreshLink

16 Mar 2006 8:41 AM

Asim Tozlu

Hi NG,

i have two MS Access-Database. The tables from database a are link to
database B.

How i can refresh the links when i move a database to another place.

thanks

greetings from berlin

asim

16 Mar 2006 4:39 PM

Mary Chipman [MSFT]

Access/Jet does not automatically refresh links. You will need to
delete all existing links and create new ones. You can write a
procedure to do this using DAO or ADOX. Code is available if you
search online or ask in one of the Access newsgroups.

--Mary

Show quote

On Thu, 16 Mar 2006 09:41:12 +0100, "Asim Tozlu" <a**@wertuzti.de>
wrote:

>Hi NG,
>
>
>i have two MS Access-Database. The tables from database a are link to
>database B.
>
>How i can refresh the links when i move a database to another place.
>
>thanks
>
>greetings from berlin
>
>asim
>

16 Mar 2006 7:52 PM

Paul Clement

On Thu, 16 Mar 2006 09:41:12 +0100, "Asim Tozlu" <a**@wertuzti.de> wrote:

¤ Hi NG,
¤
¤
¤ i have two MS Access-Database. The tables from database a are link to
¤ database B.
¤
¤ How i can refresh the links when i move a database to another place.
¤

Although it uses VB 6.0 the following MS KB article should help:

http://support.microsoft.com/?kbid=275250

Paul
~~~~
Microsoft MVP (Visual Basic)