[AccessD] Relinking Foxpro Tables

Should be some useful code here
ALink21 <http://www.colbyconsulting.com/UsefulFiles/ALink21.zip> Carl 
Tribble's Back End Relinker code
at http://www.colbyconsulting.com/
under menu item  useful files

David Emerson wrote:

> I have an Access XP application which links to Visual Foxpro tables.
>
> There could be several versions of the data in separate folders (but 
> each folder contains copies all the required tables).
>
> I would like to be able to ask the user for the folder name for the 
> tables, then change all the linked tables so that they are pointing to 
> the new folder.
>
> Can anyone give me directions for doing this in code.  My guess is 
> looping through the current linked tables and replacing the table path 
> with the new path.
>
> The description string for one of the tables is:
>
> ODBC;DSN=Visual FoxPro 
> Tables;SourceDB=d:\PMS\Data\20050215;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;;TABLE=rs2YTD 
>
>
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> 25 Cunliffe St, Churton Park
> Wellington, New Zealand
> Ph/Fax (04) 478-7456
> Mobile 027-280-9348


-- 
Marty Connelly
Victoria, B.C.
Canada