Not really studied it, but first point to note is that where you are saving the file to is different to where you are calling it in the SQL string.

Just putting my two penny-worth in, go with the adp/ade approach, from my experience it makes overall management a lot easier and more secure.

In terms of speed it is a...

I do not think it has yet been established if the original poster wants to recreate a SP type data manipulation in a standalone access db (if not why are...

Sounds obvios I know but you have checked that your network has not got any restrictions as to what traffic is transferred, or more specifically what is blocked.  For that...

Not using reporting services but should be the same as Exchange, and other IIS services that require login - under your IIS web site properties you will find a directory...

You do not need any form of third party software, if you have already got html reports working then all you need to do is change your response content type...

RAID 1 can certainly be hotswapped, if it is a hardware implentation (which in your situation it is) - if you have only got the five disks then really you...

Surely though if it truely is a row Unique ID (I am assuming here that this is your PK) you will never able to SELECT DISTINCT since the Unique ID...