Prevent damaged database

[paul]

Hi,
I have a Access 2000 application with 20 users. Recently
I got error message, "*.mdb needs to be repaired or isn't
a database file, user may have unexpectedly quit while
Access was open". I applied the Repair utility and it was
fixed. Is there a way to prevent it happen again? Can I
find out which user is the one to be blamed? Thanks.

 

[Bruce M. Thompson]

I have a Access 2000 application with 20 users. Recently

I got error message, "*.mdb needs to be repaired or isn't
a database file, user may have unexpectedly quit while
Access was open". I applied the Repair utility and it was
fixed. Is there a way to prevent it happen again? Can I
find out which user is the one to be blamed? Thanks.

See the following page at Tony Toews' web site for information on some of the
known causes of MDB corruption:

Corrupt Microsoft Access MDB Causes
http://www.granite.ab.ca/access/corruptmdbcauses.htm

Also, see the following MS Knowledge Base article for ideas on things you can do
to help keep your database good condition:

HOW TO: Keep a Jet 4.0 Database in Top Working Condition
http://support.microsoft.com/default.aspx?scid=kb;EN-US;300216