News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, November 15, 2011

Convert linked table to local

There is an easy way to convert linked table to local in Access 2010, in other words – import linked table into local database, using acCmdConvertLinkedTableToLocal command:
 DoCmd.SelectObject acTable, "Company", True RunCommand acCmdConvertLinkedTableToLocal

Command is mentioned in Office Help, but not really documented. Thanks to fellow MVPs for pointing to it!



Blogger Pat Wood said...

Thanks for posting that valuable tip Alex!

6:20 PM  
Anonymous Thierry said...

Hello Alex,
Are you sure this command works with Access 2007 ?

The site specify that this command's appeared with Access 2010.


10:14 AM  
Blogger Alex Dybenko said...

Hi Thierry,
well, not sure, don't have Access 2007 around. Have you tried it on 2007?

1:07 PM  
Anonymous Thierry said...

Yes I have tried it and it doesn't work on 2007.

2:21 PM  
Blogger Alex Dybenko said...

ok, thanks, i will update post!

2:23 PM  

Post a Comment

<< Home