Run code automatically when last user exits?

M

mscertified

Is it possible to run a piece of code when the last user exits my multi-user
database? The code is likely to take a minute or so to run so I'd like it to
run and then close the database so the user does not have to sit waiting for
it. It's going to export some data to a file for importing to a data
warehouse.
 
J

Jeff Boyce

Depending on your circumstances, another approach might be to link to the
file containing the data used to import, and updating that file on the fly,
rather than as a batch export job.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Run code automatically when last user exits? 5
Word 2003 won't exit 8
VBA - exporting serial letters to single documents 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Want to have macro execute automatically when doc created 3
Page numbering with Merged Document and IF statements 1
to run code when user click on CTRL-F 6
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top