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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Macro (or VBA/Module) To Determine If Runtime Environment Is B 6
Compact & Repair, Open table, close table, then run macro 3
IPad remote 10
Access AutoExec, Runcode Error 2001 1
VBScript question - connect and open an Access DB 2
Problem with VBScript to open a database 1
Schedule to run a Function not using AutoExec 1
Call a macro from commandline with existing autoexec 1

Back
Top