I work on client databases, sometimes on-site, sometimes in my office. When moving a database, typically, the links are not valid at all locations. The attached db consists of a table and 2 forms. One form is the parent which should be opened, the other is a subform.
This db allows the maintenance of up to 3 different sites, or sets of links for multiple locations. Simple to maintain and implement. Features include search and replace for quickly changing links.
Just import the two forms and the table into your db and open the parent form and make your life easier. Written in Access 2010 32-bit, accdb extension, compatible with Access 2007 and forward.