I have set up an Excel sheet that retrieves data from an Access database that
is stored on the local network. Microsoft Query stores the location of this
database with reference to a drive letter (i.e. S:\database.mdb). This causes
problems if another user tries to use the spreadsheet when the other user has
their drive letters mapped differently. Is it possible to store the data
source with the full address (i.e. \\server\path\database.mdb)?