Is there a way to make access delete the records in a database when it is
closed?
Ummm...
Why?
Normally the purpose of a database is to *store* data, not discard it!
You can run a Delete query; if you put a Close button on a form (such
as your switchboard) you can run a delete query from that button's
code. Post back if that's what you want to do. But I'm really curious
why this should ever be necessary!
John W. Vinson[MVP]