Msacces update queries not updating
Simply select the check boxes for the ones that you think need to be verified and updated, and then click OK.
In the Navigation pane, simply select the table you want to unlink and then press the Delete key or click the Delete command in the Records group on the Home tab on the ribbon. Note: If you click the Cut command in the Clipboard group on the Home tab of the ribbon to unlink a table, Access does not display the confirmation message.
If you move some or all of your linked tables to a different location, you must either delete your linked tables and relink them or update the location information before you can open the tables.
If any linked table has been moved to a different location, the Linked Table Manager prompts you with a dialog box so that you can specify the new file location.
You can also select the Always Prompt For New Location check box to verify the file location for all linked tables.