Split Database Log-off users

N

Neil Greenough

If I have a multiuser split database and want to create a back-up of the
backend, is there a way of logging off users automatically or giving them a
message saying something like "You have 5 mins to complete your work before
you will be logged off. This is due to administration reasons" and then
actually being able to log them off?

I know there are things such as Total Access Admin software, however just
wondering if my work will fork out the money for such.

Thanks
 
S

Sam

Douglas

I run a split data base where the FE is on each users C:\ drive and the BE
is on a share drive.

Do I add the form (as per the Check http://support.microsoft.com/?id=128814
or the KickEmOff2K sample ) to the BE or to the FE versions of the data base.

From what I could see of this, I had to double click on the DetactIdleTime
form to get it to start timing the period of inactivity. Is there a way of
automating this process based on a FE/BE setup???
 
D

Douglas J. Steele

The Microsoft code would definitely be added to the FE.

Since the only thing that's supposed to exist in BEs is tables, I would
assume the same is true for Arvin's example as well.
 
S

Sam

Thats a fair call Douglas...

How do you auto execute the file then? I had to physically clicl on the
DetectIdelTime form to get it to start counting!
 
D

Douglas J. Steele

You shouldn't need to do anything.

If you read the KB article, the form doesn't even need to be visible.
 
S

Sam

Followed the instructions to the letter, still need to click on the form to
start it timing for inactivity.

it appears that the Action macro does not start the process If I run the
macro (by clicking on the macro) then it appears to work. In a multi user
environment (FE & BE) I cannot expect the other users to activate the detect
idel time form each time they login. Is there a way of starting the action
macro automatically????
 
D

Douglas J. Steele

First, are we talking about the Microsoft KB or Arvin's code?

The Microsoft KB doesn't use macros, and I doubt Arvin does, so I'm not sure
what "Action macro" you're talking about.

One possible thing to check for. Look at the properties for the Form:
specifically on the Event tab. Make sure that it has [Event Procedure] for
the On Timer event.
 
Top