Can updating links be automated?

[BullwinkleTMoose]

We use Access 2016 and have a number of databases with external links to Excel or Text files.


These links have to be updated each month as we get new files.

Is it possible to set up a macro or module that would update these links automatically?

If we needed to update a directory or file reference in the VBA code, that would be OK. Would like to eliminate the potential errors that come when you do each link manually.

Thanks.

[ranman256]

if the excel filename changes, then you must link manually to pick the new filename. Relinking wont work on a new file.
if the filename did NOT change, then theres no relinking needed.
what did you want to automate?

I always save my new files and overwrite the old generic name: c:\temp\DateFileAccts.xls
then no relinking is needed.

[June7]

As ranman said, and as long as the file structure remains the same, replace the file and the link should persist and the revised data automatically 'updates' through the link.

This is assuming the new files are cumulative data and therefore replacing the older file is appropriate.