Create a form that opens in hidden (not Visible) mode. That form has other
uses as well. It can store session wide variables, etc. When Access closes,
that form will close also, and you can use the Close event to eun a backup
routine. Keep in mind that's really only good for a workstation database. A
split database running the data back-end on the server, may have other users
still in it, you then take a chance of either throwing an error, or worse,
corrupting the backup (or even the working database). In that case, the
regular server backup is better equipped to handle the backups of your
database.