Code

[David Kennedy]

Can anyone tell me the VBA code for :
Get Eternal Data > Link Tables

I want to put it behind a command button.

Thanks in advance
David K

 

[Jeff Boyce]

David

Have you checked Access HELP on these topics?

 

[David Kennedy]

I have checked Help,there is info on how to do it by clicking File>Get
External Data etc..
but there doesnt seem to be any examples how to do it by code

 

[Bas Cost Budde]

I have checked Help,there is info on how to do it by clicking File>Get
External Data etc..
but there doesnt seem to be any examples how to do it by code

And if you open any code module and press F1? You will likely get a
complaint about a keyword; ignore that, and see the subjects.

 

[David Kennedy]

All I get is an error saying "microsoft access cant display help"

 

[Bas Cost Budde]

All I get is an error saying "microsoft access cant display help"

Oh. Try to install it, it't helpful.

In the meantime, you can use docmd.transferdatabase aclink