David Emerson
newsgrps at dalyn.co.nz
Wed Feb 23 17:25:40 CST 2005
Tried that. The problem is that all the linked tables are Foxpro free tables. Carl's code and Candace Tripp's code both check to see if there is a field in the table definition. If so then it assumes that the link is valid. However, it seems that the table can be viewed in design mode ok but when the table is actually opened it causes the error. Also, all I want at this stage is to be able to take a variable with the folder name in it, and then loop through the linked tables to change the old folder to the new one. David At 23/02/2005, you wrote: >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 > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com