limiting time on a database

D

Devon

I am looking for VBA code that could be used to limit the
time a person could be logged onto an Access 2002
database, which is shared on a network. At the present
time, employees are logging onto the database at the start
of the day, and remain in there until it is time to go
home.

Any suggestions?
 
J

Jake

Devon

Try this website out. I think it has what you're looking for

http://www.peterssoftware.com/isd.ht

Jak


----- Devon wrote: ----

I am looking for VBA code that could be used to limit the
time a person could be logged onto an Access 2002
database, which is shared on a network. At the present
time, employees are logging onto the database at the start
of the day, and remain in there until it is time to go
home

Any suggestions
 
G

Guest

I had a similar desire with our office's photo/contact
directory.

Users access the app via a form designated as the startup
form. I set the form's Timer Interval property to 900000
milliseconds (15 minutes). When the 15 minutes is up, the
On Timer event triggers a procedure with a single line of
code: DoCmd.Quit. However, I also added Me.TimerInterval
= 900000 to the On Current event, to restart their 15
minutes every time they flipped to a different record.

FYI, I also found that viewing the database's .ldb file
with QuickViewPlus was very handy for identifying who was
still on when I needed to kick people off to do
maintenance.

Hope this helps.

-John McEnany
 
Top