Hi everyone-
I have an urgent issue on a project. I wrote an upload that pulls thousands of records into 14 tables. They select the file, upload it to the server, and click Import to do all the SQL stuff. The problem is that sometimes when they go back to click "reset form" and upload a new file, it throws the "file aready in use" error. I tried to just do a delete on the file if it exists, but never accounted for the fact it was still open... duh! so then I tried to just reopen this file and close it using a filestream.. no dice! any ideas would be great. Only 1 person uses this(for now) so if I have to kill the process I am fine with that...
Thanks in advance.
--File Upload Function
Go to the complete details ...