Link to Network Drive

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

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
 
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.
 
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
Click to expand...

Reference it by its true network name instead of your mapped drive-
ie, if it is on a server called "myserve" then you would reference "\
\myserve"
 
Yes, that's what I want to do, but I can't see a way of doing it, I go into
Data>Import External Data>New Database Query, but then I do not get an
option to use the Network drive path, just the 'H' drive, I have tried to
modify the existing query but can't see a way of doing it there either.
 
Back
Top