How to shut down program at work time end

[ياسر]

I want to let data base access to shut down on time
example:
when time becomes 4:55:00m
message box is active :
(database will shut down after 5 mints So Please save Your Work now before
:5:00:00m)
then when time is 5:00:00m database shutdown itself
till next day at 9:00:00:Am except Friday and Sunday it can't be open in
those 2 days .

 

[Gina Whipp]

Whilte I have routines to shut down the application because of inactivity, I
have never seen one that locks users out for two days. So here I am wanting
to work Saturday or stay late Monday and I can't because I am locked out of
the database??? Okay, I digress...

Here are a couple of links for down a database because of inactivity. I'll
let someone else tackle the keep users out.

http://www.peterssoftware.com/

http://support.microsoft.com/kb/304408

Perhaps, the more important question is why? For instance, if you are just
trying to supply some updates then there are other ways to handle that.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ياسر]

I m not taking about inactive times
i need to shut down database access when time becomes 5:00 pm
every day except two days they are Friday and Saturday because they are
vacation in the company but before the program shut down i need to send
message to all users warning them that the database will shut after 5 minutes
before time comes 5:00:00 pm
thats all in need
thank you for the replaying and waiting for your answers

 

[Gina Whipp]

I realized what you were asking however, trying to shut down Access at a
specified time is not an easy task. You have to consider the inactive time
because suppose they need more then 5 minutes to finish up what they are
doing?

Take a look at what I dug up... You will still have to check for idle time.

http://groups.google.com/group/comp...oup=comp.databases.ms-access&q=kick+users+out

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ياسر]

i can increase the time before i shut down db
but can you help me in doing what i need ?

 

[Douglas J. Steele]

Did you follow the link Gina gave you?

 

[Clif McIrvin]

Have you examined the examples at the links Gina sent you?

Are you familiar with programming using Access' built-in VBA editor? (or
another programming environment)? If you are not, you will need to
learn (volunteers here can point you towards helpful information if you
need it) to accomplish what you are asking.

She (and other volunteers here) will be happy to answer specific
questions you have about what something means, or helping you to step
through the process of making something work if your code isn't doing
what you expect it to.

 

[Gina Whipp]

Sorry, but no...

As I said trying to accomplish what you are trying to accomplish is going to
be VERY difficult. The time involved would be far more then I could
dedicate on a volunteer basis not withstanding I've never attempted such a
feat. I fear you may have to hire someone and still not sure how... but it
would be interesting. Keep in mind, it's not just shutting Access down,
it's keeping them out from Friday till Monday.

Best of Luck,
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ياسر]

yes i follow the link
but its all about inactive and kick out users on timer
i need to let the db do this without using any bottom i need to do it with
coding on event
so i don't think that i need to follow up the links
if there is away to do it here so please tell me
and i'm very thankful for your help
waiting for your replay

 

[Pieter Wijnen]

Not extremly hard to do (but avoid using msgboxes as they freeze the app).
I suggest using a hidden form with a timer (as gina & her samples point you
to)
the timer should check for these conditions:

(pseudo code)
if weekend (jewish in this case) then shut down immediately as you're not
allowed to open the db
elseif time >=16:55 & invisible then show the form (non modal, no close
button(!), but ok button) with an approperiate warning
elseif time >=17:00 then shut down
else do nothing
endif

hth
pieter

 

[ياسر]

thank you pieter
But let me ask you some questions please
I have to do the following steps check me if i 'm wrong
1- make unbound hidden form with warning text closing in five minutes
2- on timer event i will put the code you write
3- in the main form i will run command to open the unbound form i made to
run in the beginning with application

then what is the value to put in timer interval?
what to do with days work off (Friday and Saturday )
so when the user came to the company in those two days He can't run the
application any way.
knowing that the application is done by ms access 2003
and splitter to the server as back end
thank you for reading and waiting for replay

 

[Clif McIrvin]

thank you pieter
But let me ask you some questions please
I have to do the following steps check me if i 'm wrong
1- make unbound hidden form with warning text closing in five minutes

Yes .. and you can use the timer code to adjust that text from 5:00
minutes to 4:00 minutes to ... 1:45 ... as you see fit so when the form
becomes visible you have a countdown timer on the screen.

2- on timer event i will put the code you write

Yes -- in the new unbound form.

3- in the main form i will run command to open the unbound form i made
to
run in the beginning with application

I would suggest that you make the unbound hidden form the form that
opens on startup and have it open your main form *after* it has
determined that the user is allowed to open the database and has started
the timer. [I suspect this is the method used in the examples Gina
pointed you towards.]

then what is the value to put in timer interval?

You get to choose that value. The examples Gina supplied will have
suggestions.

what to do with days work off (Friday and Saturday )

As per Pieter's suggestion, the hidden time form will close the
application on startup so the user never sees it open.

so when the user came to the company in those two days He can't run
the
application any way.

You will have to research how to defeat the "hold shift to bypass the
startup form" feature of Access.

knowing that the application is done by ms access 2003
and splitter to the server as back end
thank you for reading and waiting for replay

Good Luck!