In previous tips, I talked about the ADO Recordset's ability to save to a file and be reloaded from the file into memory. A reader asked how to manage multiple recordsets and remove them when needed. The first question is simply a matter of keeping track of the filenames you use. For instance, if you're allowing users to write queries and then save their results, you might want to keep track of the recordsets you created by using another database. The database would link the users to their recordsets, and then you could name the recordsets using the database's primary key, for instance, or name them using a date, user ID, and so on. The combinations are endless.
The second question can be easily solved using the FileSystemObject, which can easily delete files from the server, assuming you have permissions to do this. Of course, if you had permission to write the recordset in the first place, more than likely you've got permission to delete the same file.