Must Change the Path to Linked Tables

[michaeltrombetta]

My computer crashed, and I was able to restore it. Originally I had used the User Name Mickey, but in the restored computer I (stupidly) used the name Michael. My database looks for my linked tables in C:\Users\Mickey\Documents\AccessTables, which of course does not exist anymore. How can I tell Access to look in C:\Users\Michael\Documents\AccessTables?

Thanks loads.
PS I developed this database 25 years ago, and what I remember would not fill a thimble, so I am very grateful for any help.

[JoeM]

Right-click on a Table name, select "Linked Table Manager", place a check next to the Tables(s), check the "Always prompt for new location" box and click OK.
It will then prompt you to browse for the location of your linked tables.

[michaeltrombetta]

Thanks JoeM, but I'm not out of the woods yet.
The Linked Table Manager lists my 2 tables Authors and Books. Both are in C:\Users\Mickey\AccessTables. I selected both of them, and clicked "Always prompt for new location", and clicked OK.
A new window opened "Select New Location for Authors". I navigated to the folder I want, in the File Name ....Just as I'm trying to tell you what went wrong, I saw my error. I typed Authors in place of Books_Tables. When I did that, it worked perfectly. So thank you very, very much.

[JoeM]

You are welcome! Glad I could help!