Updating all the references to external files in .accdb files

[Dean000]

Hello Together,

Does anyone knows a solution to change the path of the linked files in an Access database file? I'm thinking in a script, first we need to get the list from the accdb about the existing file references, then modify them.

It is required because all the files will be moved from their current places to another file share so these accdb files will lose their connections to the linked files and they will become useless completely. Somehow these paths need to be updated automatically. We are talking about hundreds of files, there's no solution to do it manually, it is impossible in a short term.

Thanks in advance,
Dean

 

[Estuardo]

G'd evening Dean,
May be is my bad english, but i don't understand if you are talking about the references to libraries (ADO, MS Office, CDOS, etc) or talking about the paths to external files (icons, images, docs, etc). For the first case you may want to check this site.for the second why not the startup path?