Run code automatically when last user exits?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 01 Jun 2007 16:11 GMT

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.

Reply to this Message

Jeff Boyce - 01 Jun 2007 16:20 GMT

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

> Is it possible to run a piece of code when the last user exits my
> multi-user
[quoted text clipped - 4 lines]
> it. It's going to export some data to a file for importing to a data
> warehouse.

Reply to this Message