Acess DB Corrupted HELP

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

Guest

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 said:
What's causing this
Click to expand...

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.
 
Back
Top