The Doc Man didn't suggest a way to do this when the main database is opened, which is my question.
If you want to do this each time the database is opened, you NOW have the problem that you need to see if the file was deleted earlier when you opened the database. Then closed it, went away for lunch, and came back and opened it again. (Or got up for a potty break, or maybe the boss called you to his office for a moment... - surely you do not leave a database open on your desktop if you have to walk away for a moment...?)
IF you have a form that is identified as the database's opening form, you can put something in that form's Form_OnOpen or Form_OnLoad event routine to test for the existence of the file and just delete it. OR have code to disable errors for a moment, kill the file while ignoring errors, and then enable your error handling.
If you DON'T have a designated opening form (or opening macro), you pretty much have a problem because code doesn't run in the database without some predefined context. I.e. Access doesn't run anything unless you tell it to run something, and if you are going to run code, you need to have a "medium" in which that code can run. Such as in the class module of an opening form, or in a RunCode option in an opening macro.