[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
_________________________________________________________________
Quick access to your favorite MSN content and Windows Live with Internet
Explorer 8. 
http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN
55C0701A
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com