Hello all,

Hoping someone can help me here.

I have an excel file that pulls in external data to two of the worksheets
from Access database queries located on a server.

I have no problem setting this up if I use mapped drive letters but...

My question is, is there any way to get external data using a UNC path
rather than a drive letter path?

The file can be opened from the access database front end but the
possibility exists that not every user will have the network folder mapped to
the same drive, hence the desire to use a UNC path.

Any help would be much appreciated

Thanks in advance

--
R.Douthwaite.
Information Coordinator
www.swift-research.co.uk