I was testing this today, I opened the main database window in my Access 2003 database, clicked the Queries tab in the list of objects, selected Query1 and pressed the delete key. It just disappeared. No "Are you sure you want to delete this query?", it was just gone.
Is there some way of making a prompt appear in this scenario?