97 database crashing

[TXprogrammer]

I have an Access 97 Database with about 10 tables (this is my data). I have built a 97 and 2000 database that uses linked tables to that data. There are about 10 people that use either the 97 or 2000 off the server. They all have shortcuts on their desktops and the database (97) with the data is on the server as well. The problem is that about once a week the main table (on the 97 database with the data) is getting corrupted and when I try to run a repair it crashes and is gone.

Any comments or suggestions?

 

[theprez]

The database is probably not gone. The utility renames the dabase to something else (i.e. db1.mdb, db2.mdb). Once the repair utility completes successfully, the orginial dabase is deleted and the new compacted/repaired database is renamed back to the original name. Look for a dbX.mdb (X is some number) in the same folder as your 97 database.

The reason the dabase may be corrupted is because user's may be accessing the same record at the same time. This occured to me when I had users opening a form that opened to the same record in the recordset/table.