I checked one of the spreadsheets that I have linked to one of my Access
databases, and I didn't see a way to change the query drive letters. Looks
to me like you'll be better off creating another workbook or sheet with the
new query for the time being.

"Keith" wrote:

I have a spreadsheet which links into an Access database, the database is on
a shared drive which I see as the 'H' drive, however there are a few users
of this file who see it as their 'K' drive. I need to change the connection
from the drive letter to the Network drive path to enable another user to be
able to update this data in my absence but I can't see how to so this, any
help would be very gratefully received.

Thanks