[AccessD] Relinking Foxpro Tables

Gustav,

This is the first time I have had to work with Foxpro data.  It comes in 
two forms - All tables in one file (like Access), and what they call free 
tables (where each table is in a file of its own and has a dbf extension).

No fields - It seems that even when the connection string is changed the 
design of the new tables has not replaced the design of the old ones (until 
Access is fully closed, reopened, and the front end opened again). \

David

At 24/02/2005, you wrote:
>Hi David
>
>"Free tables" with no fields? What is that supposed to mean?
>
>/gustav
>
> >>> newsgrps at dalyn.co.nz 24-02-2005 00:25:40 >>>
>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;Backgro 
> undFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;;TABLE=rs2YTD
>Website: http://www.databaseadvisors.com