I need to link my Access DB to an Excel spreadsheet. The problem is that both the database and the spreadsheet reside on a network drive. It is highly possible that people may have this network drive mapped to different drive letters. For example, I have this drive mapped to H: but I know the guy that sits next to me has it mapped as J: and yet another guy has it mapped to G:
I've tried to get everyone to agree to a standard drive letter for this drive, but no one wants to change, and the PC support guys aren't helping either. There are about 100 potential users of this app, and several different drive mappings I'm sure.
So I guess what I'd like to know is if it's possible to create a data source in Excel that connects to a network drive, but doesn't use a specific letter to connect. in other words, something like //computer/directory/myDB.mdb instead of H:/directory/myDB.mdb
Any help would be appreciated.
Thanks,
Dana
I've tried to get everyone to agree to a standard drive letter for this drive, but no one wants to change, and the PC support guys aren't helping either. There are about 100 potential users of this app, and several different drive mappings I'm sure.
So I guess what I'd like to know is if it's possible to create a data source in Excel that connects to a network drive, but doesn't use a specific letter to connect. in other words, something like //computer/directory/myDB.mdb instead of H:/directory/myDB.mdb
Any help would be appreciated.
Thanks,
Dana