RE: [AccessDevelopers] Re: Relinking DBF's under a different source file name

Thu, 15 Sep 2005 09:05:26 -0700

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



Reply via email to