I have an Access db that has a table that is linked to a text file for its 
info that is on another internal server. I can not move the text file 
because it is an extract from another system that is placed there 
automagicly. When using a DNS I get an error "'\\SERVER-PATH' is not a 
valid path.Make sure it's spelled correctly or that you are connected." 
For both security and user reasons a drive can not be mapped on the web 
server to the file server and for some reason Access does not like my UNC. 

Is there a way to create an open connection to the file I need that Access 
can then use to get the info for the table?? I am positive there is, i am 
just not sure how to do it. I've been stuck on this for 2 days now :-/

P.S.-The file is in a directory structure that only allows certain user 
groups access to the folders.