I am trying to relink to existing linked csv and txt files, although the location may be different it is always realtive to the mdb file
I have tried using the following code
(GetPath returns the location of the database, the data is stored in the /RAWDATA folder
the tdf.SourceTable Name returns the name of the file i want relinked BHIFEE
strFileName returns:
C:\Users\toby\D ocuments\Client s\TDL Mick\July\RawDa ta\BHIFEE.TXT...

I have a access 2000 database (currently running jet3.6) that has linked TXT and CSV files
I need to be able to move the location of the database often, the linked data will always be in the same place /Rawdata/ relative to the MDB file
is there anyway this can be automated to relink into the current location?


Thank you for your attention

Toby

I need to create a dual primary key in MS Access using code. Can anyone help please?