The linked table manager displays all the links used in the Access database. It can be used to update the links if they have not updated yet.
The linked table manager can be brought through the External Data ribbon:
In the figure below you can see the links used in this database:
You can select the links to update.
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com