Hello,
I have a MS Access database on a shared folder on the intranet.
On my local machine I have an Excel report in which I linked a few queries from my MS Access database.
In the Excel I make the data more presentable by using pivots and calculated KPI's from that data.
The data is not linked through a mapped drive but with a network path like: \\Share\folder\database.accdb
The database gets updated now and then and when I want actual data in my Excel report I perform a Refresh All in the Excel and the report is up to date again.
This all works with no issues on my PC.
Now I want other users to have the ability to update the same Excel report whenever they like also using the connected queries from MS Access.
These users have access to the share.
For some reason however the users can't update the data and get a "can't update"-error.
When I test with the users to access the share they have no problem.
When I try to redefine the linked query in Excel on their PC the are able to locate MS Access, select the query to link and when clicking OK the same error message occurs.
What can be the problem here?
Gr,
Ron
Bookmarks