Linking to documents on another server

I am designing an intranet for a law firm. Everything works fine. My problem is that they need to include the documents that are relative to specific cases in their database. These documents are on a different computer and I cannot find how to link to them at their current location. I have found ho

Date query and date removal

This will seem an easy question, but I cannot find a sample anywhere: I have a database of bands appearing at a club. I want to update the list sorted by date and have the results only show current date and beyond (i.e. - remove band that played last night from results page). This query is drivin