Access Excel lock

M

marco

I have build an Access application which opens excel and
bulds a report in code.
When I am running this program and it crashes halfway or I
stop the code running it's not possible to remove the file
it has already made in the Windows explorer. Also in code
it's impossible to remove the generated excel file. It
looks like Access is putting a lock on Excel and I don't
know how to unlock it, except by restarting my pc.

Marco
 
Top