Forum Discussion
Linking Access to Excel does not work
I have created a simple Access that is connected to a linked table to an Excel file as a data source.
I can run the Access without any problems. It accesses the data and everything is fine. But when my colleague wants to run the Access, she gets the following error message
"Microsoft Access “C:\Users\User\[Source Path].xlsx” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located."
We use OneDrive/SharePoint in our company and the colleague has access to the folder where the Excel and Access files are located. But it doesn't work. I think it's the path, as it seems to be local. But I don't understand why.
This Access in turn serves as a source for another Excel (the target file). There it has a similar error message:
‘’Microsoft Excel [DataFormat.Error] “[File Name].accdb” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located."
I can open and run both the Access and the target Excel without any problems.
Thanks a lot in advance. I appreciate your help a lot.
Please verify the permission and try share in common path since OneDrive syncs files to different user directories (C:\Users\[YourUser]\OneDrive vs. C:\Users\[ColleagueUser]\OneDrive), which can result in broken links when someone else tries to access the file.
