Cad Coder
asked on
Backing up Access Linked table to separate Access Db
Backing up Access Linked table to separate Access Db using VB.net and Visual Studio 2012.
I have tried code I found on Expert Exchange published 2010-03-30 by DDB. It uses ADODB which does not work well with Visual Studio 2012.
I have tried code I found on Expert Exchange published 2010-03-30 by DDB. It uses ADODB which does not work well with Visual Studio 2012.
"linked table". This makes no sense if you are not running the process within Access. From outside Access, you should always, only address the BE database.
Simplest way, which I've done before, is run an SQL query that copies the table.
E.G. SELECT * INTO New_Table from Linked_Table.
But if you give more info, then I can give a fuller answer.
E.G. SELECT * INTO New_Table from Linked_Table.
But if you give more info, then I can give a fuller answer.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.