X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Docmd Transferdatabase Acexport Creates A Linked Table., Access 2016    
post Dec 2 2018, 05:30 PM

Posts: 1,143
Joined: 1-December 12

When I run the code below it creates a table named "LPArchive2018" that is linked to the source table "LPCurrent".
I don't want a linked table and don't understand why it is linked to the Source table in the same location?

DoCmd.TransferDatabase acExport,"Microsoft Access","E:\LPBE\LPCurrent_be.accdb",acTable, "LPCurrent","LPArchive2018",false

My goal is to create new tables that contain this years records for the purpose of archiving data. Is the TransferDatabase the right tool?

Thank you
This post has been edited by InfoHound: Dec 2 2018, 05:31 PM
Go to the top of the page
post Dec 2 2018, 05:53 PM

Access Wiki and Forums Moderator
Posts: 74,973
Joined: 19-June 07
From: SunnySandyEggo


Apparently, not for your situation. The TransferDatabase method creates a copy of an object into another database. If the table you’re copying is a Linked table, then you also get a linked table as a copy. If you want to convert a linked table into a local table, then you could try using a Make-Table query.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Dec 2 2018, 05:59 PM

Posts: 1,143
Joined: 1-December 12

Thanks , I'll do that.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th April 2019 - 03:47 AM