I have a problem with mapped drives with Access. I have a shared s: drive where people go to use our access database, one of our admin accounts people is on another workgroup within the building that has another s: drive already so her drive is mapped to y: . When she opens the database it can not connect to the file path on the s: drive for the other part of the access database which is contained in another folder on our s: drive. I get a invalid path message each time this Access database is opened.
I have been through the help files and tried to locate where the setting is for changing the path of the link to the other database but every option I think is close like the Link Table Manager or the properties or even going to tools then options is disabled (greyed out) so I am unable to sort the problem.
The drives can not be renamed which is unfortunate as that would solve the problem.
Any help or ideas with this would be appreciated.