Run query before closing database

  • Thread starter Thread starter Ann
  • Start date Start date
A

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.
 
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!
 
Back
Top