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.