Locking Access Database

  • Thread starter Thread starter Bob L
  • Start date Start date
B

Bob L

We have a database that many people share on the server.
We back up our servers around 8:30pm. On a rare
occurrance, we may have someone here trying to access that
database at that time. We have found, that this corrupts
the database and records within the database. Is there a
way to lock people out of the database between a certain
time in order for it to get backed up without someone in
the database and without effecting the backup? It
wouldn't matter if we moved the backup time because if we
have a system or job problem there could possibly be
someone here accessing this database at any time of day.

TIA,
Bob L.
 
What I would do is have your server actually log any user out of the
network. If they happen to be in the office you can pop-up a message that
they will be losing network capabilities and to close any open programs.
Give them a countdown, such as in 30 seconds. If user level security has
been placed on the database, you can also write VBA code to log them out of
the database, with a warning of course.
 
Back
Top