Originally Posted by ITguy1981
I'm currently using Access 2007. Under "Database Tools" there is an option "Linked Table Manager". Just check the boxes of the tables you need to link, I normally click the "always prompt for new location", and then click okay. You will then be prompted to browse to the location of your backend database file. You may want to take the checkmark out of the check table location prompt afterward. Hope this helps.
Checking the Always prompt for new location is the norm. It doesn't need to be unchecked after doing so though. It won't be checked when you bring up Linked Table Manager again. Also, if you don't check that box it will just attempt to link to the existing location again, which wouldn't be what someone normally wants. Microsoft should have made the checked checkbox a default.