Hello Tom, As far as I know dumping the connection string and re-entering it is not only the best way of doing this, I think it's the only way.
Regards Robin. --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> wrote: > I'm linking DBF files, and need to programmatically re-link them to files > that are exported from another app. The problem is that the file names > change. TOTALS.DBF is the original file name, I'm sorting it into a > subdirectory, renaming the file according to its timestamp, and need to > relink my Access table to the newly named file. > > The Connect property for DBF files does not specify the filename, it just > assumes that it's the same as the table name. I could drop and recreate the > link (which is what I'm doing now), I'm just wondering if anyone has a > easier method. I've tried modifying the SourceTableName property to the > filename, but it doesn't seem to like that. > > Thanks, > > Tom Oakes > Personal PC Consultants, Inc. > [EMAIL PROTECTED] > 503.230.0911 (O) > 402.968.6946 (C) > 734.264.0911 (F) ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
