linked tables issues

[WexxexWorker]

Hi I have some linked tables listed as: "G:\Documents\QA Database\Data.XLS"

which works fine, but

other users have this drive labelled differently, for example "Z:\Documents\QA Database\Data.XLS"

So when other users run my queries they don't work!

Is there any way to get around this?

[Minty]

You shouldn't rely on mapped drives for this sort of thing - always use a UNC path

"\\Fileserver\share1\QA Database\etc"

[JoeM]

Use UNC paths instead of mapped drives for your linked tables.
See: https://stackoverflow.com/questions/...use-a-unc-path

[WexxexWorker]

Use UNC paths instead of mapped drives for your linked tables.
See: https://stackoverflow.com/questions/...use-a-unc-path

I ended using a trick in excel :

add a url in Excell and then the lower ADDRESS box provides the ful UNC Addesss!!!!

[pbaldy]

Post 4 was moderated, I'm posting to trigger email notifications.