Reset a field in a Access database on a schedule? Help!

[Scott G-S]

Is there a relatively simple way to reset a field in an Access database at a
scheduled time? If so, how?

Background: I'm deploying a simple electronic in/out board that uses a web
page as its interface and an Access database on the back end. In the
database, there is a table called "users" containing a field called
"inout" - if inout is set to I, the person is in, if it's set to O, the
person is out. Simple enough.

What I'd like to do is run a simple scheduled process to set inout to O
every night at, say, 8:00 pm; that way, the default state for all of the
employees here in the morning will be "out" and they'll have to check
themselves in.

Any suugestions? Full disclosure, btw - I'm not an advanced Access user,
it's just that the guy here who would normally do this gave up on it and I
feel like there MUST be a way.

Thanks in advance,

Scott G-S

 

[Guest]

A. Have a startup function which does two things
1. Checks an entry of the last logon date
2. If the logon date is different then run a procedure/query to update the
value
B. As well set a timer on your main form to do the same
You have the timer to cover the possibility that a user does not shut down
Access when s/he goes home.
You will need to create a Macro called Autoexec which runs the function at
startup
HTH
Terry