Form On-Close event

  • Thread starter Thread starter Johnb
  • Start date Start date
J

Johnb

Hi all
I have a table that collects data throughtout the time
that Access xp is open. There abiut 15 users at any one
time. When the last user exits I wish update other tables
with info held in the collecting table before Access
shuts down. Is OnClose the best approach?

TIA johnb
 
I would guess each user has a copy of the form, and a link to a central db.
If you are recording who opens the application and who closes it by writing
to a central db then yes you could use the OnClose.

ie OnClose
If recording table shows no more users then . . . . .
end sub

I think the problem may be, what if all users do not exit the system? What
if someone's machine crashes before executing the OnClose code?
 
Back
Top