Hi All

I need some help with access, i dont have much knowledge about access but trying to do something very complicated..


i have made a access and excel link file... in which i have my raw data saved in access and the pivot being reflected in excel... but the only drawback is that when i strat sharing this file on using a shared folder on the network the other users are not able to use the file.... whever the report is refreshed by them they get an error stating the path of raw data that is saved in access that the path is not accessible,,, however they shouldnt get this message because what they are trying to access is the excel file not access... i tried to solve this issue by givin the access of the raw data as well but no go... any fix to it or if there is someone who can let me know, how i can store my data by using Access and analyze it by using Excel and that too if i need to put it on the network sharing folder for other users to access it