Locking Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A few months ago, I had created a DB and for some reason it locked itself
and we were unable to re-open it. We had to start all over with massive data
entry. Ever since then I have been backing up the DB in a zip drive just in
case it happens again, yet even with my back-up I am always afraid that the
DB will lock itself again. What causes the DB to lock itself and how can I
prevent it? Does it have to do with the number of users using the DB? Is
there even a limit?

I am sure someone will help me.
 
Patty,
Your database probably because corrupted. I'm guessing that is because it is
shared by multiple users across a network. You should split the database.
Put the backend on your server and give each user a copy of the frontend on
their own PC. Yes, there is a limit to the number of concurrent connections
to an Access database -- 255. At least, that's the system limit. The
practical limit is much less than that -- more like anywhere from 25 to 50.
 
Back
Top