I have an excel file that is updated by an ms access query. When we moved locations I am the only person who can update the file. I believe it has something to do with the letter drive that our network folder is located on. We all use the same letter but I believe this is the problem.

How do I link the query so that it uses the exact network file verse a drive letter?

Get External Data - New Database Query - MS access - ok - ... Then I run into problems. I select network and go directly through the server and I cannot seem to get it to work?

Can anyone help???