limiting time on a database

  • Thread starter Thread starter Devon
  • Start date Start date
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?
 
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
 
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
 
Back
Top