I have a database that is use for data entry, updating records, running
queries and report and other functions. It is being used by 15 to 20 users in
my department. The problem is it's often corrupted, "the Microsoft Jet
database engine cannot open the file". Whenever this happened, I had to ask
all users to exit the database so I could do a repair, records are not
updated or loss sometime because of this. What's causing this, is it because
users have the database open most of the time even they are finished using
it? Is it a security access issue?

We don't have any security set up at this time for this database. What
should I do to prevent this DB corrupted problem.
Thank You

Kim_Quest wrote:
The most common cause is multiple people sharing the same database file.
Make sure the database is split with a copy of the front end (forms, queries,
reports, etc) on each user's desktop and the back end (tables and
relationships) on the network.  Link the front end to the tables in the back
end.

The next most common cause is either faulty networking equipment that causes
dropped connections or users who hit the power switch while the database is
open.  Access requires stable network connections.

Password for CurrentUser()
special permissions on database
Adding new users to an Access 2002 DB
How to remove Security from Access 2002
Network ID ans user level security