It seems that the person who send the Access file with link to the data so it works on her/his end but not on yours as the path changed. If this is the case, either let the person tell you the file location and then you can link to the file from the Access file. Or, just let the person imports the data to the Access file and then send the Access file with imported data to you.
Hope this helps.