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:
Command is mentioned in Office Help, but not really documented. Thanks to fellow MVPs for pointing to it!
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: Access
posted by Alex Dybenko | 12:34
5 Comments:
Thanks for posting that valuable tip Alex!
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
Hi Thierry,
well, not sure, don't have Access 2007 around. Have you tried it on 2007?
Yes I have tried it and it doesn't work on 2007.
ok, thanks, i will update post!
Post a Comment
Links to this post:
Create a Link
<< Home