opening a recordset & deleting a file

[charlotte49er]

I'm using ASP & ADO to create a dBase file. When I am finished, I close the recordset and connection objects and set them to Nothing. However, if I then go into Windows Explorer and try to delete the new file I can't. After a period of time I can delete. Why the delay? I can foresee that later in the asp I am going to need to open a new recordset from the file and use the freshly inserted values to create a new field but this will be impossible if it keeps reporting back that the file is already open. Any insight is greatly appreciated. Thanks.

 

[Sheco]

Why did you go to delete the file in the first place? Were you testing to find some other error?


Maybe the web server is trying to be nice and make a database connection pool for you, so that it doesn't actually close the connection when you tell it to do so.

 

[charlotte49er]

The only reason I went to delete it was because while refreshing the page I would get a "Permission denied" error. After not being able to delete it I realized that the file wasn't being released immediately eventhough I'm telling it to. Have you ever run into something like this? I'm using IIS so is there a way to force it to release? Thanks.