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!
at

5 comments:

  1. Pat Wood6:20 PM

    Thanks for posting that valuable tip Alex!

    ReplyDelete
  2. Thierry10:14 AM

    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

    ReplyDelete
  3. Alex Dybenko1:07 PM

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

    ReplyDelete
  4. Thierry2:21 PM

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

    ReplyDelete
  5. Alex Dybenko2:23 PM

    ok, thanks, i will update post!

    ReplyDelete