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