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.