[AccessD] Relink Multiple BE

 Thanks Charlotte,

 

I guess what I'm asking is do I have to link...or import first...then append?

 

just had an idea???   I could loop through the table names (rst!tblName)...use transferdatabase...each time call it the same name tblMyTable...append: "insert into " & rst!tblName & " Select * from tblMyTable "

...then delete tblMyTable...loop and do it again?

 

Sounds good on paper...any thoughts?

 

Thank,

 

Mark

 

 
> Date: Mon, 13 Apr 2009 14:50:00 -0700
> From: cfoust at infostatsystems.com
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Relink Multiple BE
> 
> Are you relinking? It doesn't sound like that's what you want, since
> you also talk about appending data.
> 
> It might not be what you're looking for, but we always used a bunch of
> tables in our Access databases that were just for that, to copy data in
> and then do any necessary manipulation before appending it to the
> existing table. Because the temporary tables didn't have PKs or FKs or
> any constraints and there was one to partner each active table, we could
> bring records in that would have aborted the transfer otherwise, and
> then we could deal with them as needed. 
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Monday, April 13, 2009 2:40 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [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(r): Now available on your iPhone or BlackBerry
> http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover
> _Mobile1_042009
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Rediscover Hotmail®: Get e-mail storage that grows with you. 
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Storage1_042009