To change the path for linked tables in access

 To change the path for a set of linked tables in access database

1. Open the database that contains links to tables.
2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
3. Select the Always prompt for new location check box.
4. Select the check box for the tables whose links you want to change, and then click OK.
5. In the Select New Location of <table name> dialog box, specify the new location, click Open, and then click OK.