Linked table to change

[mari_hitz]

Hi everyone,

You have always helped me a lot, so I hope you can do it now too :$
I have a database created in my PC and it is created based on one table that is linked to an excel spreadsheet that I have in my computer.
However, obviously when another person wants to use it in their computer they can't because the document path is not correct. These people has this same excel document in their PCs.
How can I do to update the path and indicate for this table to be linked to the file named exactly as the one I have in my database in their PCs?

I do not know if I made myself clear. Thanks!

 

[robina]

The file needs to be places on the shared drive and the path changed to reflect that.

 

[speakers_86]

Why is the excel file not on a network drive?

Perhaps the second post here will help.