[AccessD] Reattaching Tables

I have some code that does some of what you want to do but will probably  
require some fiddling.  I will dig it up this week end and either send it to  
you off the list put it on my web site.  It may already be there.  I don't  
remember whether it is well documented.

Steve Goodhall, MSCS, PMP

-----Original message-----
From: ap cx <accesspro at cox.net>
To: 'Access Developers discussion and problem solving'  
<accessd at databaseadvisors.com>
Sent: Fri, Dec 21, 2012 16:52:23 GMT+00:00
Subject: [AccessD] Reattaching Tables

I am looking for some code to relink tables from multiple back ends
selectively. That is, sometimes I want to use certain tables in one location
and some times other locations. 
I have used a number of procedures that check if linked tables are still
linked per the last use and if not relink. 
My need is for a front end that has about a hundred linked tables. 
My vision is a prompt that would ask me if all the tables previously linked
to a location should be relinked there or ask for a new location. And repeat
for other previous locations. But not for each individual table.
Of course the thing to do is write this myself; but naturally, I need it
yesterday to do a good job on this project.

TIA
Bob Heygood

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com