[AccessD] Relink Multiple BE

Thanks Stuart,

 

Just thought of that...sounds perfect.

 

Thanks again...

 

Mark
 
> From: stuart at lexacorp.com.pg
> To: accessd at databaseadvisors.com
> Date: Tue, 14 Apr 2009 08:00:48 +1000
> Subject: Re: [AccessD] Relink Multiple BE
> 
> It would be quicker if you:
> 
> For each existing BE:
> Link and open the first table
> Link, append, delete the rest
> Append, delete the last.
> 
> Keeping the first table open will speed up accessing the others.
> 
> And here's a simple function to do the Link, append, delete:
> 
> Function GetData(tablename As String, datafile As String) As Long
> DoCmd.TransferDatabase acLink, "Microsoft Access", datafile, acTable, tablename, "tmp" & 
> tablename, False
> CurrentDb.Execute "Insert into " & tablename & " Select * from " & "tmp" & tablename
> DoCmd.DeleteObject acTable, "tmp" & tablename
> End Function
> 
> 
> 
> On 13 Apr 2009 at 21:40, Mark A Matte wrote:
> 
> > I have a list of all tables and which MDB they are in...I need to loop
> > through this list and populate the local copy of said table. 
> > Transferdatabase imports and creates new table...but I want to append
> > the data to an existing table. Should I link 1...append...delete
> > link...link new...append??? 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Rediscover Hotmail®: Get quick friend updates right in your inbox. 
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Updates1_042009