P
Paul
I have a large access database, that links to an Oracle back end, the
database has 50+ users, and I am constantly updating it with new features.
I have created an option in one of the Oracle tables that the front end
checks every time the user performs an action such as opening a form, if the
option is set to -1 then the database front end shows a message box saying
that I am performing an update, and then it closes the database.
My problem is where users have left their PC with the front end open, and
gone into meetings etc.
What I would like to do is add a timer to the main form that checks say
every 2 minutes if my oracle table value is -1 and if it is closes the
database.
I suspect this will be a problem because the main form does not have the
focus for most of the time.
Any suggestions appreciated, and how to use the timer function too as I have
no experience with it.
Thanks
Paul
database has 50+ users, and I am constantly updating it with new features.
I have created an option in one of the Oracle tables that the front end
checks every time the user performs an action such as opening a form, if the
option is set to -1 then the database front end shows a message box saying
that I am performing an update, and then it closes the database.
My problem is where users have left their PC with the front end open, and
gone into meetings etc.
What I would like to do is add a timer to the main form that checks say
every 2 minutes if my oracle table value is -1 and if it is closes the
database.
I suspect this will be a problem because the main form does not have the
focus for most of the time.
Any suggestions appreciated, and how to use the timer function too as I have
no experience with it.
Thanks
Paul