Linked Table Manager

You can use the Linked Table Manager to reconnect the linked tables after the file name or path of the location of the linked table file has changed, for example after moving the back end database.

You willl have to do the relinking on a PC with Access fully installed, because making design changes in Runtime is not supported.

You can start the Linked Table Manager from the ribbon (or menu) or from the Settings formLinked Tables tab.

More info: http://office.microsoft.com/en-us/access/HP051876231033.aspx