2147206452 The file is in use by another application

[Delphin]

I have a VB6 program that exports out a Crystal report as a PDF every 2 hours to a web portal to overwrite the file in question. If someone decides to open the file rather than download it, how can I kill the old report to prevent this error from happening?

Billy Ballard

For in the past, Lies the future.

 

[EBGreen]

I don't think you can. In your situation, I would give the end users a script that will download the current version of the pdf to their local hard drive and open it for them. This will remove some of the temptation for them to open it from the share. In your code, I would trap the error and email myself when it occures so that I could take steps to determine who has the file open and correct their behavior.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]