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.

 

[Marshall Barton]

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?

Use the Unload event of an always open form. If you do not
have such a form, you can use the AutoExec macro to open a
small, invisible form when the database starts up.

BUT, there is no guarantee that the database will be closed.
E.g. power outage, pull the plug, task manager, etc. It is
much safer to clear it all the old data tables when the mdb
starts up, right before you import the data tables.

 

[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!