repair and compact?

[dean]

We have a db that the employees use to schedule vacation,
it is set up to only allow a certain amount of people out
per day, lately it has been letting people "sneak "
through it is letting more then the allotted number sign
up, it is not doing it consistently but just once in a
while. Do i maybe need to compact my db? Or is there
something else to look for to stop this?

thanks

 

[Chris Nebinger]

Comopacting on a regular basis is important, but I doubt
that it is the cause of your bug.

You will need to find out when your DB is letting more
people through, and troubleshoot from there.

Chris Nebinger