Just a innocent question.. In order for the query to return correct row count, doesn't the stats of the indexes of the tables in the database need to have been...

may be you should check your NT authentication login on that folder, which I have seen sometimes might cause such errors.

Also were you able to access this file with the...