HDI save an open database(within MSACCESS) to somewhere else.

[Biggles]

Hi,
I need to present a user with a Access Report. The user then needs to
determine if he wants the presented report and all the accompanying data that
is in the new database. This I have done.
What I do not know is:
1, How do I get a piece of code to run when Access is being closed (so I can
ask him if he wants to save the database).
2, How to save the enitre database elsewhere(for house keeping and security).

Bit more detail.
I Shell the instance of MSACCESS then use GetObject to attach(automation) to
the database and add queries reports etc. I then detach and leave it to the
user to have a look. The user may or may not close it. When the user does the
file should be saved to a different location. Or the MSACCESS will be
removed.
Later I will delete the original database. I am using FileDialog to present
an option to the user. However the save as option does not seem to work, but
the others do ?