We are developing a WINFORM APP that runs intranet that manages document files (.DOC's and .PDF's). This WINFORM APP uses MS SQL 2005 to track the cases and file names - but actually copies the files to a file server in the background.

Now - the question.

We will have translators log into a webpage to download documents that have been assigned to them to translate.

Do we have to physically move the files to a "folder" in the virtual directory for the download - or is their any other methods or tricks we can use to get the files from the file server (which is inside the network).