File already in use???

[rtgordon]

I have a process where the user will upload an excel spreadsheet, I connect, store the data into an array (which I will populate a SQL Server DB with), close connections and recordsets and set them to nothing, then delete the file.

It works fine... the first time around. The second time around, I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Excel Driver] Could not use '(unknown)'; file already in use.

What could I be missing? Anything I could check for/destroy before I try to open/connect?


TIA
Gordon

 

[lobstah]

i've gotten that error when i've viewed the file in the browser, then tried deleting it right afterwards. seems the server is slow to release.......

is there something in your processing that would mimic that?

 

[rtgordon]

I think that I have isolated the error. It seems as though it is related to making it a transaction. If I remove the transaction logic, it works. This doesn't make any sense. (I would like to transact this).

gordon

 

[joeisbatman]

HEY! I had a similar problem using an access database- Believe it or not it was a PERMISSIONS SETTING. Go one by one and verify that you have ALL permissions turned on to read write, etc. That will be able to rule out this problem-

Good luck
joe