AccessBlog.net

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

About Me Search
Alex
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!

Labels:

5 Comments:

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 http://www.accessruncommand.com/list/listc.htm specify that this command's appeared with Access 2010.

Thierry

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

Links to this post:

Create a Link

<< Home