Hi,

My DB is split into front and back end, most of the tables are linked
to Oracle database. At the moment, I'm using a hidden form to detect
idletime and close the database after x minutes of idletime - see
http://support.microsoft.com/default.aspx?scid=KB;en-us;128814

I would rather have a table (say, 'tblMaintMode')which indicates that
Access is in 'maintenance mode' or normal mode, simply by using yes/no
or 0/1 value. Then the idletime form would check the value in this
table and shut Access only when it is in Maintenance mode. I'm not
sure how to have Access read this table and respond accordingly.
Here's what runs when idletime is detected;

Sub IdleTimeDetected(ExpiredMinutes)
DoCmd.OpenForm "frmAccessShutdown", acNormal
End Sub

What I'd like to do once Idletime has been detected is;
Check the value in the tblMaintMode, if equals 'yes' then continue
with shutdown, else reset idletime timer.

Any suggestions most welcome, I'm just testing code just now...

Thanks,

FrankyG

ps I Assume I could use the same principle on Startup, check the value
in tblMaintMode, if 'yes' then display message to user and shutdown,
else do nothing? would that work?