Removing people from my application

[Guest]

My database runs on a company server, everyone has access to it.

Sometime when I go to make modifications it doesn't allow me to as other
people are viewing the application. Is there a function within access that
allows me to kick everyone out of the database.

My problem is more with people leaving their computers logged into the
database when they go home on a night.

Any help would be appreciated


Christopher Buxton

 

[Wayne Morgan]

If the main problem is people staying logged in when they are gone, I would
recommend something similar to this:

http://support.microsoft.com/kb/210297/en-us

If you prefer, you could set this up by checking the time of day instead of
how long the user has been inactive and close Access for them if it is after
that time. The main thing is that you have to decide what to do if they left
a record partially completed and you have to let the users know that you'll
be doing this so that they will know what to expect. I would also recommend
a warning form with a countdown timer in case the user is still there for
some reason. This will allow them to abort the shutdown if they are actively
using Access. You could then use the server's open files utility to see who
still has the file open and contact that user to ask them to close the
database.

 

[Mike]

if you want you can split the database and have a front end and a back
end so the access database can have multiple users at the same time,
and you wont have any problem if the other users forget their computer
on and has the database open.

let us know if this works for you.

 

[Wayne Morgan]

No, this won't allow you to work on the back-end. It will still be open by
the front-end file with the linked tables.