Linked Tables

[Bill4tektips]

Is there any way to link tables from an Excel spreadsheet and get it to relative addressing? At the moment it is doing absolute addressing so that if you move the spreadsheet and the database, then the link is broken.

 

[lupins46]

No.
Link address are always absolute.
You have to use the Linked Tables Manager or add code to try to relink automatically based on whatever rules are sensible in your case.

 

[Ed2020]

Bill,

The filepaths for linked tables/spreadsheet are absolute. You can move the frontend wherever you like and the links will continue to work. If you move the backend/spreadsheet files then the links will no longer function.

Do you mean you want to store the frontend database and linked spreadsheet files in the same directory and, if the files move, the database will automatically relink the spreadsheets that are in the new directory? This can be done, but you'd need a VB routine to run on startup of the database.

Ed Metcalfe.

Please do not feed the trolls.....

 

[Bill4tektips]

Thanks lupins46 and Ed2020, I think I will just leave them all in the same folder and it will save any problems.

 

[Ed2020]

Alternatively it would be possible to store the file names in the database and, if the spreadsheets have moved, search all drives/directories for instances of files with the same name.

This could be problematic though as it's always possible that the file names have been used more than once.

I always try and avoid using linked/imported spreadsheets anyway cos they don't work properly in all scenarios.

Ed Metcalfe.

Please do not feed the trolls.....