Logging users out!

[Emma Hope]

I have a database with a large number of users each of
which has their own login.

I need to be able to kick all the users out. The system
the db is on is slightly strange, it has a number of users
who dial in to the network and a number through normal
type entry. Sometimes the dial up users are kicked out of
their dial up, this mean that Access is quit unexpectedly
and needs to be repaired.

It won't let me repair the database, it gives an error
message saying someone is still in it and although the
user doesn't think they are, they are. So is it possible
to kick everyone out from a database that needs repairing.

Secondly i want to be able to manually kick all the users
out when i need to make changes.

Thirdly i would like to be able to set up an automatic
kick out overnight so if anyone has left it open they will
be kicked out.

Also is it possible to have a thing where a message pops
up on every logged in users screen telling them something,
i.e. they will automatically be logged out in ten minutes
or other such messages as i deem necessary?

Thanks for any help you can give.
Emma

 

[Rick B]

Kicking htem out to make changes is not needed if they each have thier own
front-end database. You should split your database if you have more than
one or two users.

As far askicking them out, build a table with one field called "status" you
will go in and update this. You might make "1" mean open, "2" mean 10
minute warning, "3" mean 5 minute warning, "4" mean closed"

Build a form in the user's front-end database that opens hidden when the
database is opened. Have it check the table. If the entry is a "4", close
Access. without warning. If the code is "3" have the form become visible
and display a message that tells them they have 5 minutes to get out,
Similar code if a "2". If "1", do nothing.

Use the form's timer to go out and check this table every 2 or 3 minutes.

Put a button on the form that rehides the form.

Don't allow the users to close the form.

Hope that helps,

Rick B

I have a database with a large number of users each of
which has their own login.

I need to be able to kick all the users out. The system
the db is on is slightly strange, it has a number of users
who dial in to the network and a number through normal
type entry. Sometimes the dial up users are kicked out of
their dial up, this mean that Access is quit unexpectedly
and needs to be repaired.

It won't let me repair the database, it gives an error
message saying someone is still in it and although the
user doesn't think they are, they are. So is it possible
to kick everyone out from a database that needs repairing.

Secondly i want to be able to manually kick all the users
out when i need to make changes.

Thirdly i would like to be able to set up an automatic
kick out overnight so if anyone has left it open they will
be kicked out.

Also is it possible to have a thing where a message pops
up on every logged in users screen telling them something,
i.e. they will automatically be logged out in ten minutes
or other such messages as i deem necessary?

Thanks for any help you can give.
Emma