I worked in the \iT section of a large government department and was asked to look at an MSAccess application that had been provide by an external supplier for recording sick absences in Police departments. It had suddenly stopped accepting new data and the supplier had said it would take weeks and cost several grand to fix it as nobody had taken out a support contract with them.
I asked the person who passed it to me if the record number of the last record was 32,767? How did you guess that he asked? It turns out that the record number column was defined as an integer and had reached its limit. I redefined the column as a long integer, which fixed the problem in about 10 seconds at the cost of bugger all.