No, when you use sql server, you are not linking to a file. You NEVER even a specify a file location when using sql server. You are linking to a server box.
In fact, this means that you can use an IP address and even link to a server over the internet. Thus, when you use sql server, ms-access...