Link to home
Start Free TrialLog in
Avatar of Cad Coder
Cad CoderFlag for United States of America

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.
Avatar of PatHartman
PatHartman
Flag of United States of America image

"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.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.