I had a situation where we were putting data into tables that had date stamp in the name. I created a table containing the name. From there I retrieved the name and connected to the table. Don't know if this helps. Jackie
--- Tom Oakes <[EMAIL PROTECTED]> wrote: > And it works - which is the most important part, > after all. > > Thanks Robin. > > Tom Oakes > Personal PC Consultants, Inc. > [EMAIL PROTECTED] > 503.230.0911 (O) > 402.968.6946 (C) > 734.264.0911 (F) > > > > _____ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf > Of Robin > Sent: Thursday, September 15, 2005 7:57 AM > To: [email protected] > Subject: [AccessDevelopers] Re: Relinking DBF's > under a different source > file name > > > 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 [email protected], "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) > > > > > > > Please zip all files prior to uploading to Files > section. > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " > on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > > * Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ > > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ------------------------ 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/
