Is this possible?

[Vallan]

Hi.

I would like to ask if its possible to close down a DB if it hasnt been used for 10 minutes?

I have a db with many users on different computers.
They forgett to shut down the db when they dont use it.

So would it be possible to automaticlu shut down the db on a computer if it has been inactive for 10 minutes?


Mattias

 

[KenHigg]

You should be able to do this with a form timer event. Do a search on the forum and you should get some good ideas...

 

[Vallan]

Sorry have tried to search the forum for help but cant find it.


I am a beginner so thats why i ask for help.


Mattias

 

[namliam]

The genaral Idea would be to use the "On Timer" event to check every i.e. minute or half minute, to see if 10 minutes have passed.

Eacht time the on timer event runs, it would add 1 to a variable and when 10 close database.

Now each time "something is done" reset this variable to 0 to allow for a new 10 minute period.

Now you problems:
- What is the "On timer" event
Just search for it and you will find many explenations
- "doing something"
What is doing something? Typing? Creating records? Changing records? etc...
You have to determain this, then work into your database that at ALL these events the variable gets reset to 0