Hi,

I am getting one error while downloading a file (DBF file) through aps page. the error is: "Can not access file because the file is being used by another process".

First My asp page creates a DBF file programmatically using OLEDB provider and saves that file at a particular location. In the same asp page I have given link to download the file on client machine.
above operation will be performed based on the flag set in my code. if flag is 'Save' it will create the DBF if flag is 'Download' it will download the DBF.
I am using ASPSmartUpload component to download the file. and i am calling DownloadFile method of this component. But it is giving me error as mentioned above. I have closed the recordset and connection object and set it to Nothing. but still it is giving this error. This works fine for the first time and after that it gives this error.

please tell me what could be the reason for this and how i can handle this programmatically. is there a way to find out whether the file is in use or not and if yes then how to stop that process? it seems like aspsmartupload component is not good for File Download purpose..

please suggest something ASAP as this is delaying my work.

Thanks