file compression problem

[psyp3]

Hello,

For reducing the file size and increasing the speed, we are introducin
the compression of the MDB files on a daily basis.

However, some of our users do not log out (or close the MDB files) an
that leads to failure of compression.

I would like to know (thru a program) how to automatically close al
the MDB if I don't find any user activity for last 3 hours - or how d
I kill all the user connections if no activity for last 3 hours.

Thanks in advance.

Best wishes,

psyp

 

[Tony Toews]

For reducing the file size and increasing the speed, we are introducing
the compression of the MDB files on a daily basis.

Presumably you meant compaction.

However, some of our users do not log out (or close the MDB files) and
that leads to failure of compression.

I would like to know (thru a program) how to automatically close all
the MDB if I don't find any user activity for last 3 hours - or how do
I kill all the user connections if no activity for last 3 hours.

HOW TO: Detect User Idle Time or Inactivity in Access 2000 (Q210297)
http://support.microsoft.com/?kbid=210297
ACC: How to Detect User Idle Time or Inactivity (Q128814)
http://support.microsoft.com/?kbid=128814

However we found that the code which runs on the timer event must be
disabled for the programmers. Otherwise weird things start happening
when you're editing code.

Also print preview would sometimes not allow the users to run a menu
item to export the report to Excel or others. So you had to right
click on the Previewed report to get some type of internal focus back
on the report so they could then export it. This was also helped by
extending the timer to five minutes.

The downside to extending the timer to five minutes was if a person
stays in the same form and at the same control for considerable parts
of the day, ie someone doing the same inquiries, the routine didn't
realize that they had actually done something. I'll be putting in
some logic sometime to reset this timer whenever they do something in
the program.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm