[AccessD] Relink Multiple BE

Hello All,

 

Current...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???

 

Any advice?

 

Thanks,

 

Mark
 
> From: dwaters at usinternet.com
> To: accessd at databaseadvisors.com
> Date: Tue, 7 Apr 2009 11:27:06 -0500
> Subject: Re: [AccessD] Relink Multiple BE
> 
> Are the tables duplicated (or mostly) in all 30 old BE's?
> 
> If so, then make a table with the names of the BE's, and a hard-coded list
> of tables in your transitioning code and then loop through that list of
> tables for each BE. Of course, that might be too easy?
> 
> Good Luck,
> Dan
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Tuesday, April 07, 2009 11:17 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Relink Multiple BE
> 
> 
> Hello All,
> 
> Inherited situation: 4 FE and 30+ BE
> 
> I have condensed...to 1 and 1. Now I need to move the BE to their location
> and populate with current data.
> 
> I'm considering a table which lists table names and what old mdb it belonged
> to...then loop through and link each one in code?
> 
> run queries againts each table appending in new single BE.
> 
> Any suggestions/comments on approach?
> 
> Thanks,
> 
> Mark
> _________________________________________________________________

_________________________________________________________________
Rediscover Hotmail®: Now available on your iPhone or BlackBerry
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Mobile1_042009