Run query before closing database

[Ann]

I am using Access 2002. I have a user who needs to do Adhoc reporting and I
want to keep her out of my tables. I have a macro that runs on the AutoExec
to transfer the database tables from the original to a new database so she
can do whatever she wants to create reports. I also have a SQL that will
drop all the tables when it's run. I don't want the user to be responsible
for running this query. I just want it to run when she closes the database.
Is this possible? Is there something on close like the AutoExec on opening a
database? Thanks for the help.

 

[Ann]

Hi,

Thanks! As obvious as that was to put it in the beginning instead of the
end and it just didn't occur to me. It worked great!