View Full Version : Database REpair


suzannedriver
02-10-2006, 04:18 AM
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
02-10-2006, 04:34 AM
Have you tried "Compact and Repair"???

KenHigg
02-10-2006, 04:36 AM
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
02-10-2006, 08:07 PM
Have you tried "Compact and Repair"???

That's funny.