Database REpair (1 Viewer)

[suzannedriver]

I have a database set up for four users which is on the server. The queries/reports etc are on each user pc. The database is crashing two or three times a day and a message saying to repair it is coming up each morning. Any suggestions on utilities to run (other than compact and repair) or anything I should be checking for in my database?

 

[reclusivemonkey]

Have you tried "Compact and Repair"???

 

[KenHigg]

The fact that it happens in the am is a starting point. The first thing I would look at how the users are exiting the database each evening. Sometimes if a user has the database open and simply turns the pc off, this will corrupt the db. Poll the users and ask them how they shut down at the end of the day...

 

[jsanders]

Have you tried "Compact and Repair"???

That's funny.