Pierre,
Best idea is unbound forms with code that reaches out to the database only
as needed. You can use the timer event of a form to write some code that
would close the form if it had been idle for a while. The way I'd make it
work is to look at keystrokes over time. I'd want something that returned a
percentage--100 being fully active, 0 being idle, that I could use to
determine if the form was idle enough to close.
It's been a while, but I believe a Jet based database sustains a stream of
packets so it can keep checking for connectivity. So, if you've got a Jet
database open but idle there is still activity generated by it regardless of
whether a form is open or not. Other brighter lights than me can answer to
this better than I can.
--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"
"Pierre" <pf@arobas.net> wrote in message
news:Ht*********************@wagner.videotron.net. ..
Hi all,
If a user open forms on a network and let it there for a while,
will it help the network if we close the form automatically after a while
or it has nothing to do with the load on a network.
What ca i do to ease the load on a network?
Best regards
Pierre