I have a spreadsheet which is linked to an Access DB table. In MS Query,
I changed the drive mapping (eg G:\data\etc) to the server name (eg
\\server\drivename\data\etc) in SQL view.

However, when colleagues who are mapped to the drive under a different
letter try to refresh the spreadsheet, it still comes up with the
error: "Cannot locate G:\data\etc"

Does anyone know why? There are many users in a large multi-site
organisation, and to change everyones mappings would be very
time-consuming.


--
alexkr